View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Vlookup and #N/A

See this:

http://contextures.com/xlFunctions02.html#Trouble

--
Biff
Microsoft Excel MVP


"kmap" wrote in message
...
I have done plenty of vlookups in the past, but all of the sudden I am
getting stuck. I don't know what else to verify in order to correct the
issue. I am receiving an #N/A. I verified that the information is sorted
appropriately, there is actually information in the referenced cell, and I
have checked the formula. I'm not sure what else to check. Don't know if
it
makes a different, but the worksheet it should be pulling from was created
by
another inidividual and pasted in. Any suggestions?
Thanks!
K
Example: =VLOOKUP(A2,Lite,2,FALSE)