Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP PullDown Menus Connected
You can do this with programming. There's an example he
http://www.contextures.com/excelfiles.html Under Data Validation, look for Dependent Cell Examples JK (New England Coffee) wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |