Subscribe
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.
Vlookup
(3 posts) (3 voices)-
Posted 4 months ago #
-
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
VijayPosted 4 months ago # -
@ 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.
Posted 4 months ago #
Reply
You must log in to post.
Welcome to Chandoo.org. New here?
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
