Question

"VLOOKUP," "HLOOKUP," and "INDEX + MATCH" are formulae that:

A) Calculate square roots
B) Retrieve data from a table
C) Sum up a range of numbers
D) Convert text to numbers

Answer 1

VLOOKUP, HLOOKUP, and INDEX + MATCH are formulae that retrieve data from a table.

Step-by-step explanation:

VLOOKUP, HLOOKUP, and INDEX + MATCH are formulae that retrieve data from a table.

VLOOKUP is used to search for a value in the leftmost column of a table and return a corresponding value from a specified column.

HLOOKUP works in a similar way, but searches horizontally. INDEX + MATCH is a combination of the INDEX and MATCH functions, which allows flexibility in retrieving data from a table by specifying both the row and column.