LookUp in Excel

In Excel, the Lookup function returns a value from a range (one row or one column) or from an array.

vLookup – Vertical lookup

hLookup – Horizontal lookup

Lets see how to create vertical lookup in our example.

1. Lets have few data in excel sheet.

Example: Lets set value for each alphabet.

Lookup data

Lookup data

2. Let the alphabets have typed somewhere in the same sheet or new sheet. Type in any of the adjacent cell as =VLOOKUP and enter ctrl+a.

VLOOKUP dialog box

VLOOKUP dialog box

3. Select the Lookup_value.Lookup_value is the data where our entered data is present. Lets say, we have typed our data in another sheet.

Lookup_value in excel

Lookup_value in excel

4. Select table_array. Lets say in our case, we need to select the data to lookup. Say in our case, Column A and B contains lookup values.

5. Set col_index_num as 2. col_index_num is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1.

6. Set Range_lookup. Range_lookup is a logical value ‘1’ or ‘0’.

‘1’ – to find the closest match in the first column (sorted in ascending order)

‘0’ – select exact match.

Default value for Range_lookup is ‘1’.

Lookup data set up in Excel 2007

Lookup data set up in Excel 2007

7. Copy formulas to the cells. The corresponding values will be updated automatically.

Copy formulas to the desired cells

Copy formulas to the desired cells

 

Share This Post

Related Articles

Leave a Reply

© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups