Class 11: Vlookup

Add Your Doubts: Click Here

Summary:  In this class, you will learn Vlookup. It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order to return a value from a different column in the same row. 

Formula: 

[Part1] Vlookup:  =VLOOKUP( Target data, table array, column index no., range lookup)

To lock the table: select and f4

[Part 2] Vlookup: When you have removed data as per (id) =VLOOKUP( lookup value, table array, column index no., range lookup)

Conclusion: In this class, Raj sir has thought you Vlookup i.e to search one data and get all the other data linked with the same.