Excel VLOOKUP Function Syntax:
This argument is the value that is searched for in the first column of the table array. The lookup _value can be a text string, a logical value (TRUE or FALSE only), a number, or a cell reference to a value.
This is the range of data that the function searches to find your information. The table_array must contain at least two columns of data. The first column contains the lookup_values. These values can be text, numbers, or logical values. This argument is a named range or a reference to a range of cells.
If you are using a reference to a range a cells, it is a good idea to use an absolute cell reference for the table_array.
If you don’t use an absolute reference and you copy the VLOOKUP function to other cells, there is a good chance you will get error messages in the cells the function is copied to.
For this argument, enter the column number of the table_array from which you want data returned from. For example:
- if the col_index_num is 1, it returns a value from the first column in table_array;
- if the col_index_num is 2, it returns a value from the second column in table_array.
A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value.
- If TRUE or if this argument is omitted, VLOOKUP will use an approximate match if it cannot find an exact match to the lookup_value. If an exact match is not found, VLOOKUP uses the next largest lookup_value.
- If FALSE, VLOOKUP will only use an exact match to the lookup_value. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, an #N/A error is returned.