Question

HLOOKUP is used for Horizontal Data look ups while VLOOKUP is for Vertical Data look ups
Select one:
True
False​

Answer 1

Answer:

True

Explanation:

Both HLOOKUP and VLOOKUP are excel functions used for searching through tables for a specified lookup value to either get an exact or approximate match. The VLOOK and HLOOKUP functions have identical syntax which only differs with the HLOOKUP requiring the row index number to search through the rows while, VLOOKUP requires the column index number to search through the columns. Other than this difference, the other syntax values are the same.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])