How to Use HLOOKUP() in Google Sheets

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 Actually Use HLOOKUP() in Sheets

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

Try HLOOKUP yourself

In cells A1:D1, you have the headers 'Name', 'Age', 'City', and 'Country'. Use HLOOKUP to find the 'City' for 'John' in the range A1:D2. Your formula should be placed in cell F1.

Your formula

Hints (3)

Locale Separator ,

Official Docs

1 Better Sheets Tutorial

Find Column with Header to Bullet Proof your Vlookup

Make your VLOOKUP formulas flexible and your data move-able with this trick.

Intermediate

HLOOKUP() MATCH() VLOOKUP()

Transcript-matched member videos for HLOOKUP(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Use Index Match when you want Vlookup

If you find Vlookup a difficult formula to understand, this formula comb...

Intermediate

INDEX() MATCH() MAX() VLOOKUP()

Unlock these tutorials

Learn more about the HLOOKUP() formula:

Generate a HLOOKUP() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses HLOOKUP(). 2 free AI generations, no signup. Members get unlimited use.

Generate a HLOOKUP() formula

How to Use HLOOKUP() in Google Sheets

Try HLOOKUP yourself

Find Column with Header to Bullet Proof your Vlookup

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Use Index Match when you want Vlookup