View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VKL Narayanan[_2_] VKL Narayanan[_2_] is offline
external usenet poster
 
Posts: 7
Default How do I avoid #NA result in a VLOOKUP

I am trying to vlookup a number stored as text. I have verified and
reverified the formula nothing seems to be wrong, the syntex is correct and
the field references are correct, but it keeps returning for all cells #NA.
How to debug this?