View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhoy yhoy is offline
external usenet poster
 
Posts: 27
Default 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