Excel

How to Use VLOOKUP in Excel

How to Use VLOOKUP in Excel

VLOOKUP is a function in Excel that allows you to look up data in a table. You can use it to find a value in a table, or to find a value that corresponds to a given position in a table.

To use VLOOKUP, you first need to create a table of data. The table should have at least two columns: the column you want to look up values in, and the column you want to return values from.

Once you have created your table, you can use VLOOKUP to find values in it. To do this, enter the following formula into a cell:

=VLOOKUP(value, table, column)

The first argument is the value you want to look up. The second argument is the table of data you want to look in. The third argument is the column number in the table you want to return a value from.

For example, if you want to find the value "Apple" in the table below, you would enter the following formula into a cell:

=VLOOKUP("Apple", A2:C6, 2)

This would return the value "Apple" from the second column in the table.

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.