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.
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.
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.
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’.
7. Copy formulas to the cells. The corresponding values will be updated automatically.