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