# Drop down menu and IF statements

#### jsflbot

##### New Member
I'm trying to do a conditional formula

Dashboard:
 A B C D E F G H I J 1 Regional Rep Region # of Item Fall outs Regional Region # of Item Fall outs 2 Drop down menu here Would like to place another drop down menu here depending on the regions of the selected rep in A2 =VLOOKUP(B2,I2:J6,2,FALSE) Steph North 3 3 Would like to place another drop down menu here depending on the regions of the selected rep in A2 =VLOOKUP(B2,I2:J6,2,FALSE) Steph East 4 4 Would like to place another drop down menu here depending on the regions of the selected rep in A2 =VLOOKUP(B2,I2:J6,2,FALSE) Steph Florida 5 5 Kevin West 3 6 Kevin NW 1

<tbody>
</tbody>

What I'm trying to do is that when someone selects a particular rep from the drop down menu (cell A1), then cell B2:B4 will automatically populate only the regions pertaining to that regional rep.

In cell C2 I have the following formula: =VLOOKUP(B2,I2:J6,2,FALSE), which pull information depending on the region I selected in cell B2.

Your help is appreciated as always!!

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Gilliam

##### Active Member
how many regional reps are there?
does each regional rep have exactly 3 regions?
If so, why would column B need a drop down?

#### jsflbot

##### New Member
There are 3 of them. One of them has 5 regions, the other one has 2, and the last one has 4.

#### jsflbot

##### New Member
Column B doesn't necessarily need to be drop down, it can be setup in a way where if a rep is selected, on column b all of the respective regions would populate in individual cells.

Replies
3
Views
210
Replies
2
Views
607
Replies
3
Views
557
Replies
2
Views
176
Replies
0
Views
554

1,190,558
Messages
5,981,690
Members
439,730
Latest member
gjvv

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back