Final answer:
The best function for retrieving data from a lookup table with values arranged in rows is HLOOKUP. INDEX and MATCH can also be used together, but HLOOKUP is simpler for horizontal lookups.option a.
Step-by-step explanation:
If a worksheet arranges lookup values in rows rather than columns, the best function to use for retrieving data from the lookup table is HLOOKUP (Horizontal Lookup). This function searches for a value in the first row of a table or range and then returns a value in the same column from a specified row. Conversely, if the lookup values were in a column, you would use VLOOKUP (Vertical Lookup).
INDEX and MATCH functions can also be used together to perform a similar task, offering more flexibility than VLOOKUP or HLOOKUP because they can look up in both rows and columns, but they require a bit more complexity in setting up. Generally, HLOOKUP is preferred for its simplicity in horizontal lookup scenarios.