I need to have cell #2 be autopopulated by cell #1 and also be able to have a
drop down menu to be able to autopopulate cell #1.

If one have of the information is known but not the other I want the ability
to query using either cell.