I know how to use the validation and list reference to create a drop down of choices for a particular cell, however what I'd like to do is base the list referece on another cell entry. For example: if cell A1 = Boston, then cell B2 will reference a particular list, however if cell A1 = Chicago, then cell B2 references a different list. Thanks
Bookmarks