View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Val
 
Posts: n/a
Default Excel 2002 Lookup formula returning wrong results?

Has anyone else had a problem with the lookup formula returning an incorrect
result? I have found that if there is no match, it will return the result
from the previous line. Does anyone have a solution?