Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Value Not Available Error in Vlookup
I'm using the vlookup function to get a number back from a table. I've
created the vlookup properly but keep getting the #N/A with the message - "Value Not Available Error". The problem is that the value is available. I've copied the vlookup formula into a number of cells - all come back #N/A. The puzzle is, I can get the formula to work if I retype the value being looked up in the table. I've compared formats; I've made sure the table is in alphabetical order; I can't see any difference from the value being looked up with the value in the table - they are even the same font. Any ideas? The table is copied into the worksheet from another workbook. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |