Microsoft Excel Training Videos

Vlookup in Excel:
Find information in an Excel worksheet quickly

How to implement Vlookup in Excel in the easiest manner:
  • First sort your Excel data in ascending using the 'sort' feature in Excel
  • 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.

Vlookup in Excel