Vlookup and #N/A
Hi,
When you use false in vlookup then there is no need to have a sorted
lookuprange.
2 things I can think off:
- Is Lite defined as the lookuprange?
- Perhaps you may have unvisible characters like space in the lookupvalue or
lookuprange.
Wkr,
JP
"kmap" wrote in message
...
I have done plenty of vlookups in the past, but all of the sudden I am
getting stuck. I don't know what else to verify in order to correct the
issue. I am receiving an #N/A. I verified that the information is sorted
appropriately, there is actually information in the referenced cell, and I
have checked the formula. I'm not sure what else to check. Don't know if
it
makes a different, but the worksheet it should be pulling from was created
by
another inidividual and pasted in. Any suggestions?
Thanks!
K
Example: =VLOOKUP(A2,Lite,2,FALSE)
|