VLOOKUP for Rows

Vlookup stands for vertical lookup. In other words, vlookup searches for information in a column. If you want to search for information in rows, you have to use the hlookup function.

Let’s take a look at a simple example with the vlookup function:

This function returns a value from a column you specify. Now, let’s look at how it works for rows:


Let’s suppose you have different data. The table headers and each fruit are inside separate columns and not rows. In this case, you can copy and transpose the table.

But if you don’t want to, or can’t do it, you can use hlookup. This function looks for a value in the top row of values and returns the value in the same column from a row you specify.

Here’s how it works:

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.