The syntax of the HLOOKUP function is as follows: =HLOOKUP(lookup_value,____,row_index_num,range_lookup).
A) table_index
B) table_array
C) table_range
D) table_row

Question

Quizplus · Accepted Answer

The correct syntax for the HLOOKUP function includes a table_array parameter, which is the range of cells that contains both the lookup value and the corresponding results. This is often referred to as the lookup table or data table. Option B, "table_array," is the parameter name that corresponds to this requirement.

The Syntax of the HLOOKUP Function Is as Follows: =HLOOKUP(lookup_value,____,row_index_num,range_lookup)