Vlookup: Using VLOOKUP is similar to looking up a person's name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.
Let's understand with example what VLookup can do for us.
Here we have two sheets, Vlookup and Example. In Example sheet we have used VLOOKUP function to get the value of Feb month for Section8. First it will go to another sheet, search our word and when it matches, it gives us corresponds value from different column.
Formula used in cell B4->=VLOOKUP(A4,Vlookup!$A$3:$G$14,3,0)
How to use VLOOKUP:
Note: Vlookup can only looks up value in the leftmost column of a table.
Explore more, It's Amazing…
2,934 total views, 1 views today