Which lookup function would you use to search for and return values from adjacent columns of a table?

Use VLookup to search down the first column of a table and return a value from another column in the same row. HLookup searches across the top row and returns a value from another row, so it is not the right choice for adjacent columns.

AI-written and checked against the verified answer.