What is/are the primary functions to look up the information stored in a list…
2024
What is/are the primary functions to look up the information stored in a list or table in Excel?
- A.
HLOOKUP
- B.
VLOOKUP
- C.
LOOKUP
- D.
All options are correct
Attempted by 72 students.
Show answer & explanation
Correct answer: D
Excel provides a dedicated suite of Lookup and Reference functions to scan datasets and pull matching values automatically.
The three core classic functions used for this purpose are:
VLOOKUP(Vertical Lookup): Searches for a specified value in the first column of a table array and moves horizontally across the row to return a value from a specified column index.HLOOKUP(Horizontal Lookup): Works identically to VLOOKUP, but searches for a value in the top row of a table and moves down vertically to return a value from a specified row index.LOOKUP(Vector/Array form): A flexible backward-compatible function that looks up values in a single-row or single-column range (vector) and finds a match from the same position in a second range.
Since all three functions serve the primary purpose of searching for table/list information, Option D is the correct choice.