What function would you use to retrieve data from a horizontal table?

To retrieve data from a horizontal table, the most suitable function is HLOOKUP. This function is specifically designed to search for a value in the first row of a table and return a corresponding value from a specified row within the same column. Since the data is organized horizontally, HLOOKUP effectively scans the first row to find the target value and retrieves information from a row below that matches the column.

In contrast, VLOOKUP is tailored for vertical tables, where the search occurs in the first column. INDEX can return a value from a specified position within any range but does not perform a search. The LOOKUP function can be used for both horizontal and vertical ranges but is less straightforward and lacks some features that make HLOOKUP more appropriate for horizontal data retrieval.