Dropdown list within dropdown list

Once the Firm name is picked from the second dropdown list I want to be able to see another drop down list that will allow me to choose address. contactnumbers, contact name or notes. Then from there I would be able to click on one of those to show me the adress etc. Is that possible. I have it vertically right now but I would prefer to do it horizonitally . I would also prefer the data to be on sheet 2. Any help would be appreciated I have read numerous forums but nothing seems to match. Thank you


Database.xlsx

The additional dropdown you want is in cell C1. It's not just a header that I typed in.

Cascading Dropdown Lookups=Database (1).xlsx

Oh sorry I didn't see that last night - It works great. You have been a great help !! BUt now that I have a look at it - I have added tabs for the different kinds of Industries on different sheets which totally messed up your formulas. I also wouldnt need the addresses on the database sheet but when I remove it it must be linked to the other addresses. Can the data be picked up from the other sheets.
Thanks LIsa

Before I make modifications, I'd like to make sure that your workbook is in its final format.

Do you plan on adding more industry types in more worksheets? Will you be adding other data fields? Is your Database sheet layout what you want? By the way, I don't recommend that type of design. Is there a particular reason you want industries segregated on separate worksheets? A single worksheet with all related data in one place gives you the most flexibility and takes most advantage of how Excel works, with features like pivot tables and filtering. (This is a different approach than true database design because it is denormalized.) I could propose a design for you but I'm not sure what you want to be able to do with this data.

Also, you said that you want to be able to select "address" as one of the options. You have multiple fields that make up the address and the cleanest way to display it is to create another field that concatenates them all together using a formula. So, yes, the address for display is linked to the address data. It is cleaner than writing a formula to display data that treats the address as an exception case.