Excel function HLOOKUP

The HLOOKUP function finds a value in the first row of a table and then returns the contents of a cell in the same column.

Let's try an example:

We will use HLOOKUP to display a person's age based on his or her fist name.

In this example, we want Steve's age.

hlookup function

And now we have retrieved Steve's age.

Now all we have to do is edit C5 to retrieve a different person's age.