I have a table with the following columns: Account, Sub, and Split. I'm trying to create cascading data validation lists where you first select the Account, then the Sub, and finally the Split. So in the table below if I chose Account = 501650, then Sub = 00-240, the third Split list should include Nash Tech and iMis. Or if I chose Account = 504950, then 00-120, the Split list should include Cell Phone and Conference Call.
All the articles and videos I've found used named ranges to populate a list based on 1 lookup value. This scenario is more like an index match match where there are two look up values.
Desired output:
The Account data validation list should include: 501650 and 509450. Assuming 501650 is selected
The Sub data validation should include: 00-240, 55-240, 77-240, 99-240, 00-120, 00-130, and 00-140
The Split list would be based on the value selected above.
Does anybody have any suggestions on how to create a data validation list for the Split column based on the Account selected then the Sub selected?
<tbody>
</tbody>
Thanks in advance for your help.
All the articles and videos I've found used named ranges to populate a list based on 1 lookup value. This scenario is more like an index match match where there are two look up values.
Desired output:
The Account data validation list should include: 501650 and 509450. Assuming 501650 is selected
The Sub data validation should include: 00-240, 55-240, 77-240, 99-240, 00-120, 00-130, and 00-140
The Split list would be based on the value selected above.
Does anybody have any suggestions on how to create a data validation list for the Split column based on the Account selected then the Sub selected?
Account | Sub | Split |
501650 | 00-240 | Nash Tech |
501650 | 00-240 | iMis |
501650 | 55-240 | CS Dues |
501650 | 77-240 | AS Dues |
501650 | 77-240 | AS Misc Dues |
501650 | 00-120 | ASAE |
501650 | 00-120 | SHRM |
501650 | 00-130 | WSJ |
501650 | 00-140 | Billboard |
509450 | 00-120 | Cell Phone |
509450 | 00-120 | Conference Call |
509450 | 00-130 | Conference Call |
509450 | 00-160 | Bren |
509450 | 00-160 | Conference Call |
509450 | 00-160 | Sound Connect |
509450 | 00-160 | Go To Meeting |
509450 | 00-240 | Sound Connect |
509450 | 00-240 | JR / Ken |
<tbody>
</tbody>
Thanks in advance for your help.