Drop down menu and IF statements

[jsflbot]

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

 

[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.