Excel

How to Do a Vlookup in Excel

How to Do a Vlookup in Excel

A Vlookup is a function in Excel that allows you to lookup a value in a table of data and return the corresponding value from the same row.

To do a Vlookup in Excel, you first need to identify the column in your table of data that contains the value you are looking for. You then need to identify the column in your table of data that contains the corresponding value you want to return.

Once you have identified these two columns, you can then use the Vlookup function to lookup the value in the first column and return the value from the second column.

For example, let's say you have a table of data that looks like this:

In this table, we want to lookup the value "Apple" and return the value from the "Fruit" column.

To do this, we first need to identify the column in our table of data that contains the value we are looking for. We then need to identify the column in our table of data that contains the corresponding value we want to return.

In this example, the column we are looking for is "Fruit", and the column we want to return the value from is "Description".

Once we have identified these two columns, we can then use the Vlookup function to lookup the value "Apple" and return the value "Description".

So, the Vlookup function in Excel would look like this:

=Vlookup("Apple", "Fruit", "Description")

And it would return the value "Description" as the result.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.