Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
getting error msg but I have tried all the tricks and I can see there are
valid matches in the data page tried sorting, formatting to general, etc etc but still get error. This never happended before, it looks like it cannot recognize or "see" the data.... anyone? thanks Jackie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Use vlookup with FALSE or 0 as the last parameter if you want exact match,
formatting to general does not make any difference if the values are text already, also you might want to check if you might have leading or trailing spaces in either the lookup value or in the lookup range -- Regards, Peo Sjoblom "jackieu" wrote in message ... getting error msg but I have tried all the tricks and I can see there are valid matches in the data page tried sorting, formatting to general, etc etc but still get error. This never happended before, it looks like it cannot recognize or "see" the data.... anyone? thanks Jackie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |