Q. What is the purpose of the HLOOKUP function in Excel?

A
Search vertically in a table
B
Search horizontally in a table
C
Count unique values
D
Filter data
Solution:

HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a specified row.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!