81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

HLOOKUP()

Description

Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.

How To Use in Sheets

HLOOKUP(search_key, range, index, [is_sorted])

External Links

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.