So I have an existing table where I am trying to compile a list of different business chains and their locations (both cities AND counties) I have 2 separate data lists that I am working with - a list of cities where the businesses operate, and a list of counties and each city within them.
One of the columns is a multiple-select where I can choose different cities where “Business A, Business B…” have existing chains. “San Francisco, Oakland, etc.”
Is there any way, either in the same cell or in an adjacent column that once I add a city “San Francisco” for example I can automatically get “San Francisco County” or “Oakland” and “Alameda County”. The maybe tricky part is that if I have multiple cities from the same county, I don’t want duplicate county names.
Thanks!
