Thread: getting #N/A when vlookup is a negative number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default getting #N/A when vlookup is a negative number
Rick B wrote:
When I do a vlookup and the lookup value is a negative number and negative
numbers are in the lookup table I get a #N/A instead of the negative number I
am looking for.



Post your current formula.
Reply With QuoteReply With Quote