Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup
Hi
I am trying to use a vlookup using the look-value from a list box and the table array has a range name. However it keeps coming back as #NA. Does anyone have any idea why as I have tried all the things I know. Thanks Noemi |
#2
|
|||
|
|||
make sure that the lookup table you have named covers all of the range your
lookup formula refers too,and that your list box values identical to your lookup values Sometimes if you are stuck try a very simple example of what you are trying,,ie type one of the lookup values in a cell with a simple /partial version of your lookup formula.You may find that your lookup values have a space in front or similar- the #NA error means excel cant find a match.if you are using the exact match syntax=Vlookup(lookupvalue,lookup array,col num,true) paul remove nospam for email addy! "Noemi" wrote: Hi I am trying to use a vlookup using the look-value from a list box and the table array has a range name. However it keeps coming back as #NA. Does anyone have any idea why as I have tried all the things I know. Thanks Noemi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |