VLOOK up returning #N/A even though value exists in lookup array

S

shaun.coley

I've had this problem before and it was fixed when I'd sort the lookup
array in ascending order. Did that, still no good. I've also made
sure both fields were text. Still no good.

But when I copy the value being looked up, and do a find for it in the
lookup array, it is found - but I get #N/A with teh formula.

Any thoughts?

Cheers,
Shaun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlook-up in report with column Expansion 5
Lookup value that falls between two values in a range and then som 2
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6
Formula returning #N/A Error---why??? 4
VLOOKUP Keeps Returning #N/A 6
How to supress #N/A in an array formula. 5
Vlookup Match BUT Returning #NA 1
VLOOKUP Function returning multiple values in a separate table 8

Top