| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Formula Help
I want to put a formula in cell I150 that says look up the code in cell G150
and go find that code in the List tab in column A, then return the text in column C on the list tab. And, if you don't find the code on the List tab, then leave the cell blank. I've tried the formula below, but its not working correctly, i get a #REF! in the cells that should return a code. =IF(ISNA(VLOOKUP(G150,List!A:A,2,0)),"",VLOOKUP(G1 50,List!A:A,2,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
| convert vlookup formula to link formula | Excel Worksheet Functions | |||
| Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
| Vlookup formula | Excel Worksheet Functions | |||
| VLOOKUP Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
