Basic Introduction to Vlookup in Excel:
Find information in an Excel worksheet quickly
How to implement Vlookup in Excel in the easiest manner:
- Select a cell where you wish to enter the function
- Then start writing the Excel function ‘=vlookup(….)’
- In the vlookup_value specify the item you are looking for, eg. ‘shirt’ •Next select the table_array, eg.A2:B7
- Now define the column_index from where you wish to find the corresponding data, eg. 2 The Vlookup feature helps to find data in the same row in another column with reference to the first column of the defined data table. It’s like looking for a phone number against a person’s name in a telephone directory.