Hire From Us

New Feature

Class 11: Vlookup Copy

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.

Please enable JavaScript in your browser to complete this form.

Enquire Now

Please enable JavaScript in your browser to complete this form.