Looking to create a filtered drop down list based on a value.
I would want to get only the Name column values where the Group column equals 'CURRENCY' into a dynamic drop down list. More values would be added so the source data would be dynamic as well. I've tried vlookup but would need to look backwards to get the name values which wasn't working out. Any help would be greatly appreciated!
CodePudding user response:
So lets assume, you have the database from cell A1 till C4, and need a dynamic dropdown in cell F2 based on Column C value CURRENCY
• First create a helper column in Cell H2 and enter the below formula
=FILTER(A:A,C:C="CURRENCY")
• Now select the cell F2, and from Data Tab, click Data Validation
• Under Settings Tab --> Validation Criteria --> Allow --> Select --> List
• Enter below formula in Source -->
=$H2#
• Press OK.
Now whenever you add new data to the original source the data validation list shall show the required Names based on the specific criteria i.e.