Hi, I have read many links here and on other sites that say how to do B dependent on A, and C dependent on B. I'm trying to make both B and C dependent on A.
I have attached a very basic sheet. In it I have A= account names. B=Corporate customer contacts, C= Cities they have offices in
Right now if I choose from a dropdown in A the company name, in B I only get the contacts names that work for that company. That part works fine. In my formula area on the right side of the sheet I have an additional area that lists the company names again (that is the "foundation" info) and this time next to it is the cities. How can i make column C offer me the cities based on column A while still having column B function as it does? I hope this makes sense, please see the attached.
Bookmarks