How to Use HLOOKUP in Google Sheets

HLOOKUP is like the less popular little sibling of VLOOKUP. Instead of finding the value in the first column of the search area and returning a value in the same row, it finds the value in the first row and returns a value in the same column.
To use HLOOKUP simply write equals HLOOKUP and specify the:
1. ”Search Value”,
2. “Search Area” and
3. “Return Row Number”
OBS! In most cases, write FALSE or 0 as the 4th argument!
So in this example, we can see that the search value is the car brand “Toyota” and the “search area” or range is A2:C6. The “Return Row Number” or index is 3, which will return the value in the 3rd row of the same column.
And as we can see, this returns the value “Ford”. However, if we change the “search value” to Red, it returns the value Yellow. If we instead change the index value from 3 to 5, it returns BMW.
One of the biggest drawbacks with VLOOKUP and HLOOKUP is that it only allows us to return values to the right and down of the found value, meaning that if you want to return a value located to the left or up of what you are searching for, you’ll have to use a different function such as XLOOKUP instead.