VLOOKUP Problem

  • Thread starter Thread starter andyp161
  • Start date Start date
A

andyp161

FALSE in VLOOKUP is for some reason returning values that do not exist.
However, when I use TRUE, those values which FALSE is erroneousl
returning are replaced by the nearest match. Therefore, TRUE i
working as it should, but FALSE is not?? Please help, for this i
driving me crazy!!!

Kind regard
 
Hi

Maybe you are searching for numbers and the cells are not formatted to
display them correctly - so it looks like the wrong results are being
returned. Post some sample data (in plain text) and your formula.
 
Back
Top