select the correct answer. which lookup funct...
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