Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.


In this lesson, we will be going through the HLOOKUP function.
HLOOKUP looks for a given value in the top row of a table, and returns a value in a different row, on the same column.
We’ll write Equals HLOOKUP. The function consists of four arguments: The value we are looking for, which is in cell B4… the table area… which row, counting from the top, we have the return value, which is the third, and TRUE for an approximate match, or FALSE for an exact match. We’ll write FALSE.
We’ll then make the table area an absolute reference so that we can copy the formula downward and get the result for each order number.
This lesson has gone through the HLOOKUP function, which is useful when trying to locate certain values in a table.