get #N/A from vlookup function
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
|