Dropdown list to show relevant options

[jonoww]

Hi

I currently have a spreadsheet that shows transactions from different companies. I would like to adjust the dropdown list to only show the relevant transaction types.

EXCEL.png

Currently there is a named range setup (I9:I20) which is where the dropdown gets its list from.

I added a column to the left with the different companies and wondered if the dropdown for 'Transaction Type' can only show the necessary dropdowns.

So for example if I select the 'Transaction Type' dropdown under Square Company, it should only show 'Lease', 'Surrender of Lease' and 'Abortive Sale'.

The Spreadsheet is just a replica of another to try and simplify it hopefully.

thanks

[dosydos]

See My attached workbook.

Pretty much you need to rearrange your table so companies are on the top and transactions for each are below them. Then you need to name your individual tables based on the Developer name. Just remember you can't use "SPACE" when naming a table.
Once all tables are named you then have to make a data validation list based on the company name so you will utilize this formula in the data validation list:

Please Login or Register  to view this content.

Above formula references the company name in column C and removes spaces so that it will match the name of your tables hence giving you the correct drop down lists.

[jonoww]

Many Thanks,

I originally did that first part by splitting the developers into columns but was using named ranges for the list validation.

This formula works better though as it auto fills the next rows automatically and works providing you add the new column for the developer.

Thanks