| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup lookup_value
I've got a very simple Vlookup function that is giving me a problem. I am
trying to find a match to a number, but can only get the match to work if I enter an apostrophe (') before the number (found in C22) and make it a text. I've checked that both the source cell and the searched cells are formatted to identical number format. =VLOOKUP(C22,Prices,2,FALSE) "Prices" is a sheet in a second externally linked workbook. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup(lookup_value) | Excel Worksheet Functions | |||
| multiple lookup_value | Excel Discussion (Misc queries) | |||
| VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup) | Excel Worksheet Functions | |||
| vlookup:same lookup_value, different returns | Excel Worksheet Functions | |||
| VLOOKUP - dealing with lookup_value differences | Excel Worksheet Functions | |||
Threaded Mode
