How to Use Lookup Functions in Excel 2016

What formula uses the correct syntax for lookup functions in Excel 2016?

There are several lookup functions available in Excel 2016, including LOOKUP, VLOOKUP, and HLOOKUP. The syntax for each function varies.

Understanding Lookup Functions in Excel 2016

LOOKUP Function: The syntax for the vector form of the LOOKUP function is LOOKUP(lookup_value, lookup_vector, [result_vector]).

The lookup_value is the value you want to search for in the range provided by lookup_vector. The result_vector argument is optional and is used to specify a range that contains the values to be returned.

VLOOKUP Function: The syntax for the VLOOKUP function is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

The lookup_value is the value to be found in the first column of the table_array, and col_index_num is the column number in the table_array from which the matching value should be returned.

HLOOKUP Function: The syntax for the HLOOKUP function is HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]).

Similar to VLOOKUP, the lookup_value is matched to the first row of the table_array and then returns a value from the specified row_index_num within that array.

By understanding the syntax and parameters of these lookup functions, users like Robyn can effectively search for and retrieve data in their Excel 2016 worksheet.