Vlookup

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.

Further reading
VLOOKUP Function Examples And Videos
Excel’s VLOOKUP Function

One thought on “Vlookup

  1. Pingback: Vlookup Excel VBA | Excel VBA Training Videos

Leave a Reply

Your email address will not be published. Required fields are marked *