I'm trying to do a conditional formula
Dashboard:
<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!!
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!!