select the correct answer. which lookup function(s) will you use if you want to search for specific data in…

select the correct answer. which lookup function(s) will you use if you want to search for specific data in a row? a. hlookup and matrix lookup b. hlookup c. vlookup and matrix lookup d. vlookup e. matrix lookup

select the correct answer. which lookup function(s) will you use if you want to search for specific data in a row? a. hlookup and matrix lookup b. hlookup c. vlookup and matrix lookup d. vlookup e. matrix lookup

Answer

Brief Explanations:

The HLOOKUP function searches for a value in the top - row of a table or an array and then returns a value in the same column from a row you specify in the table or array. It is used for row - based lookups. VLOOKUP is for column - based lookups. Matrix LOOKUP is not a standard Excel lookup function.

Answer:

B. HLOOKUP