VLOOKUP PullDown Menus Connected

[Guest]

DATA:

A1 A2 (these three colums combined in one column)
765100 SWISS MISS CIDER MIX CS $28.50
765100 SWISS MISS CIDER MIX CS $30.00
054020 SYRUP CUPS MAPLE 100-1 OZ. CS $13.30

Both A1 and A2 are pull-down menus.
If user pulls down menu and selects A1, then A2 is returned to the right of
it.
If user pulls down menu and selects A2, then A1 is returned to the left of it.

Any ideas?

 

[Debra Dalgleish]

You can do this with programming. There's an example here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for Dependent Cell Examples