View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
iguttin iguttin is offline
external usenet poster
 
Posts: 2
Default Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?

I've tried rounding both the lookup table and the value in case this was a
rounding issue.

The stranger thing is that VLOOKUP works for *most* values, but every 4th
(or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works,
101.45% works but 101.50% doesn't)