Question

How do HLookup and VLookup differ? HLookup searches for data in columns, while VLookup searches for data in rows. HLookup searches for data in cells, while VLookup searches for data in tables. HLookup searches for data in tables, while VLookup searches for data in cells. HLookup searches for data in rows, while VLookup searches for data in columns.

Answer 1

Answer:

HLookup searches for data in rows, while VLookup searches for data in columns.

Explanation:

As the name suggests HLookup stands for Horizontal Lookup where as VLookup stands for Vertical Lookup.

Please see the attached snapshots taken from Microsoft Excel for your understanding.

Answer 2

Answer: D

Explanation: