Is the lookup value text.

Try

-VLOOKUP(--lookup_value,lookup_table,2,False)

--
__________________________________
HTH

Bob

"yhoy" wrote in message
...
It seems to be an easy task however I keep getting #N/A-- I have checked
so
far:

- the "table array" is sorted
- both "look up value" and the "table array" have format "General"
- lookup value is in the "table array"

what can possibly go wrong? any help is appreciated