The lookup_value has to appear in the first column of the the table_array that is supplied to VLOOKUP. Type in the equal sign then VLOOKUP and select the suggested function. For instance you can use VLOOKUP to retrieve values from a table after typing in only part of a lookup value.
Type in the equal sign then VLOOKUP and select the suggested function.
The lookup_value has to appear in the first column of the the table_array that is supplied to VLOOKUP. This can be an actual value or a blank cell that will hold a value. In the parentheses enter your lookup value followed by a comma. The lookup_value has to appear in the first column of the the table_array that is supplied to VLOOKUP.