how do hlookup and vlookup differ?\n○ hlookup searches for data in columns, while vlookup searches for data…

how do hlookup and vlookup differ?\n○ hlookup searches for data in columns, while vlookup searches for data in rows.\n○ hlookup searches for data in cells, while vlookup searches for data in tables.\n○ hlookup searches for data in tables, while vlookup searches for data in cells.\n○ hlookup searches for data in rows, while vlookup searches for data in columns.

how do hlookup and vlookup differ?\n○ hlookup searches for data in columns, while vlookup searches for data in rows.\n○ hlookup searches for data in cells, while vlookup searches for data in tables.\n○ hlookup searches for data in tables, while vlookup searches for data in cells.\n○ hlookup searches for data in rows, while vlookup searches for data in columns.

Answer

Brief Explanations:

HLOOKUP looks for a value in the top - row of a table and then returns a value in the same column from a row you specify. VLOOKUP looks for a value in the left - most column of a table and then returns a value in the same row from a column you specify. So HLookup searches for data in rows and VLookup in columns.

Answer:

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