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

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

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

You may want to share the formula.

And look at Debra Dalgleish's site for troubleshooting your =vlookup() formula:
http://contextures.com/xlFunctions02.html#Trouble

wrote:

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

--

Dave Peterson