Asked by Sanna Gunnarsson on May 28, 2024
Verified
If a worksheet arranges lookup values in rows rather than columns, which function is best for retrieving data from the lookup table?
A) VLOOKUP
B) HLOOKUP
C) INDEX
D) MATCH
VLOOKUP
A function in spreadsheet applications that searches for a value in the first column of a table array and returns a value in the same row from a specified column.
HLOOKUP
A function in spreadsheet software that searches for a value in the top row of a table or range and returns a value in the same column from a specified row.
INDEX
A function in programming and spreadsheet software that returns the value of an element in a table or array, identified by row and column numbers.
- Acquire skills to utilize lookup functions for data retrieval and management across various tables.
Verified Answer
SA
Shihab AhmedMay 30, 2024
Final Answer :
B
Explanation :
HLOOKUP is the best choice for retrieving data from the lookup table arranged in rows. It works similar to VLOOKUP, but it searches for the lookup value in the first row of the table and returns the corresponding value from a specified row.
Learning Objectives
- Acquire skills to utilize lookup functions for data retrieval and management across various tables.