Drop down menu and IF statements

[jsflbot]

I'm trying to do a conditional formula

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

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!!

 

[Gilliam]

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

 

[etaf]

have a read here
http://blog.contextures.com/archives/2013/06/27/dependent-drop-down-lists-in-excel/
Excel Dependent Drop-down Lists - Easy Excel Tutorial
http://blog.contextures.com/archives/2013/09/26/conditional-drop-down-lists-in-excel/

 

[jsflbot]

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

 

[jsflbot]

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.