Use the drop-down menus to answer each of the following questions.Which lookup function would you use to search for and return values from adjacent rows of a table?

HLOOKUP searches across the top row of a table and returns a value from a row beneath it, so it is used to look up values in adjacent rows. VLOOKUP searches down columns instead. The correct choice is HLookup.

AI-written and checked against the verified answer.