Under the vlookup function, could you please explain range look up


7 Answer(s)


Hi Kajal,

Assume you have a value in cell A1. Assume also that you have 5 values from B1-B5.

A vlookup will check if A1 value is present in B1-B5. This range B1-B5 is called the range lookup.


Does that answer your question?

Yes. Partly. But im still not able to figure out the meaning of this question.
The range_lookup argument is either True, or False. With False, you get?


Yes. Partly. But im still not able to figure out the meaning of this question.
The range_lookup argument is either True, or False. With False, you get?


Yes. Partly. But im still not able to figure out the meaning of this question.
The range_lookup argument is either True, or False. With False, you get?


Yes. Partly. But im still not able to figure out the meaning of this question.
The range_lookup argument is either True, or False. With False, you get?


If range lookup is True then you are looking for an exact match. If range lookup is false it will not do an exact match and will also match just parts of the string.