Question

When would you use an HLOOKUP instead of a VLOOKUP?

Select one:
A. When your headings are at the beginning of each row
B. When you do not have a unique identifier
C. When you need to find an approximate match
D. When you have headings at the top of each column

Answer 1

You would use an HLOOKUP instead of a VLOOKUP when you have headings at the top of each column.

Step-by-step explanation:

When you have headings at the top of each column, you would use an HLOOKUP instead of a VLOOKUP. HLOOKUP stands for Horizontal Lookup and is used to search for a value in the first row of a table and return a value from a specified row in the same column. This is useful when you want to find data across different columns based on a specific heading.