Forum Discussion
TRUE vlookup brings the wrong results
Hello to all,
I wanted to make my full-of-vlookups workbook faster so I thought I would start using vlookups(TRUE) on a sorted table since I read that its faster that way.
Problem is that...
TRUE is used for an approximate match FALSE is used for exact match in "VLOOKUP" formula. Using false should help.
Hello,
from what I read and considering that the lookup table is sorted, TRUE returns the wrong result only if an exact match is not found.
Are you saying that the above claim is wrong?
As for FALSE being of help,
I'm not sure what you mean, it's obvious from the original post that I'm already using FALSE.
