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.
81% OFF online library of tutorials for mastering Google Sheets
HLOOKUP()
Description
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.