Data Validation Edit

Hi guys, I have a formula in Data Validation which is functionable, but lacks criteria. All is as per file and screenshot attached. Possible to take a look please? Thanking in advance!

https://www.excelforum.com/attachmen...1&d=1528129464 [EXCEL]

2018-06-04_1721.png

On my understanding:

Created named ranges for the 4 "Special Accounts" and one for "General" accounts

Add "GENERAL" to the DV list for E12

in F12

For DV

=IF(LEFT($E$12,8)="SPEC-ACC",INDIRECT(SUBSTITUTE(E12,"-","_")),GENERAL_CATEGORIES)

It works JohnTopley, thank you. Only that original file does not contain general names as SPEC-ACC, these are all different account names, while I see SPEC-ACC is specified in your formula. Would there be a way to replace that strict specification in a formula to match each different account in a file itself? I think my original formula was in a way achieving that result, only that I was lacking the additional criteria

Too, selection of just General as the account wouldn't click as there are many different accounts in a file, as mentioned in original post

All accounts, including SPEC-ACC's are in column A. I have linked SPEC-ACC's into E:H as these are the only one's that have specific categories, as this was the only way I could figure how to do dropdowns on those accounts and categories.

The challenge, however, remains with all other accounts - in E12 I need to be able to select any other account from column A, and once any other (not SPEC-ACC) account is selected, dropdown in F12 should return all categories available in column B.

Sorry for a confusion!

Modify the DV test to include a test for "GEN_ACC" (similar to the SPEC-ACC" test ) and modify the IF to STILL select "General_Accounts"

You will need to add all the "GEN-ACC" accounts to E12 DV list.

Thank you JohnTopley!