View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Samantha Samantha is offline
external usenet poster
 
Posts: 24
Default vlookup formula error

I am trying to lookup a value in one worksheet, find an approximate match in
another table, and return the corresponding value from the 2nd column of the
lookup table. I get either #NA or #REF!
Please help!?!?!