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.
|
|
|
|
|