VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Where: Lookup_value(required) - is the value to search for. This can be a value (number, date or text), cell reference (reference to a cell containing a lookup value), or the value returned by some other function. Un...
col_index_num: once the lookup value is found, this number tells excel from which column the value should be fetched corresponding to value looked up. [range_lookup]: This is an optional argument. It can either be TRUE or FALSE. This is mentioned to dictate Excel if one wants an exact...
Lookup_value:A11 or East_01 (in this example). Table_array:the range includes the location of the column lookup value and the columns where the return value is located (i.e. A1:B9). Col_index_num:the number of columns it should move to the right. In this case, the range contains ...
First, let's look at the basic syntax of the VLOOKUP function. In Excel, the syntax of the VLOOKUP function is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Where lookup_value is the number to look for, table_array is the area of the table to look in, col_...
4. col_index_num: The column number (starting from the left of the table_array) from which you want to retrieve the result. 5. range_lookup: This optional argument determines whether you want an exact match (FALSE) or an approximate match (TRUE) when searching for the lookup_value. If...
Now, let’s look into the meaning behind each argument before we go through examples: Lookup_value The value to lookup in the leftmost column of a table. Table_array The range of cells that contains the data. Col_index_num The number of the column in the table, from which the matching...
It’s unidirectional, meaning it must work with indexes fixed to the left side of the work area and will return an error or will be unable to reference the appropriate values. Because VLOOKUP references a col_index, it’s unable to dynamically update whenever you insert new columns to the ...
Argument Value Meaning Col_index_num 4 The column number where the return data is located [range_lookup] FALSE The exact value 4. Click Enter on the keyboard. VLOOKUP Example: Combining Data Sets If you want to combine data sets, a piece of data must anchor them both. In other words, ...
The core of the formula is the standard VLOOKUP function that searches for an exact match to the lookup value in I1. But since we do not know in which exactly column the sales for a specific month are, we cannot supply the column number directly to thecol_index_numargument. To find th...
Check the 3rd parameter to make sure that vlookup is looking up the right column. In this example, the table_array only has 1 column. But the formula’s third parameter (col_index_num) is 2, meaning vlookup needs to retrieve the 2nd column. Since vlookup was not supplied a 2nd column...