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.
