MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP nearest match question

Posted by Chris D on January 07, 2002 11:35 PM

Hi all,

what's the logic behind VLOOKUP's nearest match result(ie when the last arguement is FALSE) ?

does it just find the nearest match alphanumerically, starting with the first character ? or does it go on %age matches of total characters or something ?

many thanks

Posted by Seal on January 08, 2002 12:14 AM

The closest match assumes that your list is in ascending order. If it is numerical it will the closest lesser value, and if it is alpha it will the closest alphabitically ie....


looking up "vo" would return the value in corresponding column with "tom".

Posted by Scott on January 08, 2002 6:17 AM

Just for clarification here: When Range_lookup value is "False" or "0", it looks for an exact match. If the value is "True", "1", or omitted, it will return the closest match.

Posted by Chris D on January 08, 2002 9:35 AM

Good shout Scott !

I must have been half asleep - I did mean the TRUE arguement, thus asking for a nearest match : it was what did it consider was "nearest" that I was wondering about....

thanks though, sorry for the schoolboy error there !