View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick B[_2_] Rick B[_2_] is offline
external usenet poster
 
Posts: 1
Default getting #N/A when vlookup is a negative number

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.