Searched the forum...can't find exactly what I am looking for.

Suppose I have a list of team names in Column A, and a different list of team names in Column D....

How do I create a validation list in CELL E1 that will contain the team names in CELL A1 and CELL D1??

Specifically, what I want, is a formula to enter into the validation for each cell in Column E that will look in cells A:A and D:D and offer those two teams as options in the drop down list...even if the team names are changed.

Is this possible....???