Vlookup in Excel:
Find information in a large Excel worksheet
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.