View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JK (New England Coffee)
 
Posts: n/a
Default VLOOKUP PullDown Menus Connected

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?


--
Jason Kaloyanides
Tech. Support Coord.
New England Coffee
Sales Department