**What does it do?**

Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.

**Formula breakdown:**

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

**What it means:**

=VLOOKUP(this value, in this list, and get me value in this column, Exact Match/FALSE/0])

The VLOOKUP function in Excel can become interactive and more powerful when applying a** Data Validation **(drop down menu/list) as the *Lookup_Value. *So as you change your selection from the drop down list, the VLOOKUP value also changes.

Click to learn how to insert a drop down menu with Data Validation

See how easy it is to apply this with a quick VLOOKUP example below.

**STEP 1**: Go to **Data > Data Validation. **

**STEP 2**: Select **List **in the **Allow dropdown****. **

For the **Source, **ensure that it has the 4 Stock List values selected. Click **OK.**

Your dropdown is ready.

**STEP 3:** We need to **enter the Vlookup function**:

## +VLOOKUP(

The Vlookup arguments:

**lookup_value**

**lookup_value**

**What are we looking for?**

*Reference the cell that contains the text or value:*

## =VLOOKUP(G15,

*table_array*

**From which list are we doing a lookup on?**

*Place in the cell range of the Stock List:*

## +VLOOKUP(G15, $B$14:$D$17,

**col_index_num**

**col_index_num**

**From which column do we want to retrieve the value?**

*We want to retrieve the Price which is the SECOND column from our table array:*

## +VLOOKUP(G15, $B$14:$D$17, 2,

**[range_lookup]**

**[range_lookup]**

**Do we want an exact match?**

*Place in FALSE to signify that we want an exact match:*

## +VLOOKUP(G15, $B$14:$D$17, 2, FALSE)

The price now dynamically changes based on your selection:

**Helpful Resource:**