How to use vlookup in excel

1

Create a two column list toward the bottom of the page. In this example, one column has numbers and the other has random words.

2

Decide on cell that you would like the user to select from, this is where a drop down list will be.

Advertisement

3

Once you click on the cell, the border should darken, select the DATA tab on the tool bar, then select VALIDATION.

4

A pop up should appear, in the ALLOW list pick LIST.

5

Now to pick your source, in other words your first column, select the button with the red arrow.

6

Select the first column of your list and press enter and click OK when the data validation window appears, now you should see a box with an arrow on, if you click on it your list should drop down.

7

Select another box where you want the other information to show up.

8

Once you clicked that box, go to the INSERT tab and FUNCTION.

9

Once the box pops up, select LOOKUP & REFERENCE from the category list.

10

Find LOOKUP in the list