Role of VLOOKUP
Previous - Role of Enums
Overview
VLOOKUP or Value Lookup is a built-in Excel function that helps to find the required value from a range of cells. It helps to quickly return the value from a table array.
VLOOKUP could be added only to a flat file. If you have a generic file, upload the model and then add the VLOOKUP to the flat file that gets downloaded to your device.
Step-by-Step Guide
- Add a new sheet to the flat file immediately after VROI_ENUMS and name it VROI_VLOOKUP.
Provide the values and other details in the VROI_VLOOKUP sheet.
- The first column should have unique values to identify each row.
Click a cell in the VROI_INPUTS sheet where you want to display the value that you are looking for. As soon as you type =VLOOKUP(,the rest of the function - VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) appears.
- Now pull the required value by entering:
the Lookup Value (lookup_value), which is the value that you are looking for,
the Table Range (table_array) by selecting the range of data to be searched from the VROI_VLOOKUP sheet.
the Column Index Number (col_index_num) by entering the column number where the data could be found.
the range lookup value (range_lookup) as FALSE.
(i.e.; When the lookup value is passed to VLOOKUP(), it would search for the lookup value in the first column of the VLOOKUP table and identify the row from which the value needs to be retrieved. Then it checks the column index number and identifies the cell.
- Click Enter and the value in the specific cell is returned to the VROI_INPUTS sheet.
Refer to the VLOOKUP Model to clearly understand VLOOKUP
Note:
You can add any number of VLOOKUPs in a single model. However, ensure that the first column has unique values.
To add the Column Index Number, count the columns from the left. The first column of unique values in the VLOOKUP sheet is Column 1.
- The Range Lookup Value would be TRUE in case of partial matches and FALSE in case of exact matches.