Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup argument type
I have two instances using vlookup in which I look up the value '1234' in
table array. Vlookup returns #NA in case 1, and the correct result in case 2. In case 1, the value argument is a cell reference to '1234' and has a TYPE value of 1. In case 2, value is a cell reference to '1234' and has a TYPE value of 2. The TYPE value in the lookup column of the lookup array is 2. Is the wrong data type the cause for the #NA result and, if so, how do I change it? Formatting the lookup value as text doesn't do the trick. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
read in Vlookup an argument that has quotations(") | Excel Discussion (Misc queries) | |||
VLOOKUP: type or paste values | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |