vlookup using 0 for range_lookup

[amypaulsen]

just a quick question: I always use "false" for my range lookup so that my vlookup will return an exact lookup however my colleague uses a zero 0. Does this represent false the same way? What does the zero do?

As always, THANKS!

 

[Jonmo1]

yes, for the range lookup argument, there are 2 options. It is a True or False argument.

False = 0
True = 1

If you use False (or 0), it means Vlookup looks for an EXACT Match of the lookup value

If you use True (or 1), Vlookup looks for the COSEST match. Data must be sorted ASCENDING. It will find the Largest value that is Less than or Equal to the lookup value. So if it's looking for 7, but only finds the numbers 2 4 8 and 10, it returns the 4.

Hope that helps...