Forum Discussion
VLOOKUP returning incorrect results
I have a large complex workbook that I've been using for years with great success. But all of a sudden I'm getting incorrect values. Here's the situation. One tab in the workbook (let's call it ACC...
Does it help if you add FALSE as 4th argument, i.e. in C2
=VLOOKUP(A2,ACCT_PMT,3,FALSE)
and fill down?
HansVogelaar Yes, that worked! Thanks! But I don't understand why. Especially since it's been working correctly for years. Have I just been lucky?
FALSE specifies that you're looking for an exact match.
Without it, VLOOKUP will look for an approximate match, but this will only work if the first column of the lookup range is sorted in ascending order, otherwise the results are unpredictable.