Vlookup

[shivapavan]

Hi all,


Can any body explain me about Vlookup function =vlookup(b1,c1:g58,2,0)... now why we use "0" at last in vlookup function.

 

[vijay.vizzu]

Dear Shivapavan


In the above formula =vlookup(b1,c1:g58,2,0), b1 is your lookup value, c1:g58 is the data range in which your lookup value is to be searched, 2 is the column number, as per your data range(c1:g58) d1 is the 2nd column, after criteria matched in first column i.e in C column, from 2nd column i.e D column the value will be returned and finally 0 is for false, you use true or false or you can use 0 for false and 1 for true. False means exact match, and true means omitted.


Regards

Vijay

 

[Kevin@Radstock]

@ vijay.vizzu


If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.