| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking two lists to display the same data
I have two lists that I need to be linked togeather.
PSI kPa == == 100 700 225 1500 The values are the same just different units. I want the user to be able to select from two different drop down lists and have the other list show the corrisponding value in the other unit. Thank you for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking two lists to display the same data
Hi Bob,
What will be the corresponding value if two of the drop down lists are selected. Do let me know to help you out Thanks Shail Bob the Kart Racing fool wrote: I have two lists that I need to be linked togeather. PSI kPa == == 100 700 225 1500 The values are the same just different units. I want the user to be able to select from two different drop down lists and have the other list show the corrisponding value in the other unit. Thank you for your help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking two lists to display the same data
That is the thing.... I want them linked so that if you select 100psi the
other list will display 700kPa. if you select 1500kPa then the other list will display 225psi.... so on and so forth. I want them linked such that 100psi <- 700kPa and 225psi <- 1500kPa. You would not be able to have the lists display 100psi and 1500kPa or 225psi and 700kPa. I hope this clears up my question. "shail" wrote: Hi Bob, What will be the corresponding value if two of the drop down lists are selected. Do let me know to help you out Thanks Shail Bob the Kart Racing fool wrote: I have two lists that I need to be linked togeather. PSI kPa == == 100 700 225 1500 The values are the same just different units. I want the user to be able to select from two different drop down lists and have the other list show the corrisponding value in the other unit. Thank you for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Linear Mode
