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.
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.
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
@ 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.
You must log in to post.