Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a list that places data in 3 colmuns (cells) from mult row/
I am trying to create what I would call a pull down selector list . This
botton would open a pull down list , that would have multiple row with data that is selected based on a standard set of data. This selected row in the list is then placed in the three cells on the worksheet For example : spreadsheet has a botton for cell G11 to I11 the data for this comes from a list outside the working area and the list would look like this: Row Colmun D E F 20 ma 4 20 21 volt 0.8 3.2 22 volt 1.0 5.0 (select one of the three options above) (the data would be placed in the three cells on the worksheet) To me this should have been a fairly common requirement and simple to actually setup. Can anyone tell me if this is possible and if so just how I would do it. Thanks old fellow |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a list that places data in 3 colmuns (cells) from multrow/
On Apr 10, 8:26*am, old fellow
wrote: I am trying to create what I would call a pull down selector list . This botton would open a pull down list , that would have multiple row with data that is selected based on *a standard set of data. This selected row in the list is then placed in the three cells on the worksheet *For example : spreadsheet has a botton for cell G11 to I11 the data for this comes from a list outside the working area and the list would look like this: *Row * * * * * * * *Colmun * * * * * * * * * * * D * * * *E * * * * F *20 * * * * * * * *ma * * * *4 * * * *20 *21 * * * * * * * *volt * * 0.8 * * * 3.2 *22 * * * * * * * *volt * * 1.0 * * * 5.0 * * * * * * * * *(select one of the three options above) * * * * * * * * *(the data would be placed in the three cells *on the worksheet) To me this should have been a fairly common requirement and simple to actually setup. *Can anyone tell me if this is possible and if so just how I would do it. Thanks old fellow One way would be to combine the three values into one, then use the column of combined values as the list source for data validation in J11. Then use formulas in G11 to I11 that use the chosen triplet in J11 to return the appropriate single value. Using you example you could add this formula to G20... =D20 & " | " & E20 & " | "& F20 (I have used space pipe space to separate the individual column values) Then fill the formula down to G22. Then you could use data validation in J11, list, source = $G$20:$G$22. Then use this formula in G11... =INDEX(D20:D22,MATCH($J$11,$G$20:$G$22,FALSE)) and fill it across to I11. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing mult drop down list | Excel Worksheet Functions | |||
How do you use a dropdown menu to enter data in mult. cells exce? | Excel Worksheet Functions | |||
Problem protecting cells in a mult-page workbook | Excel Discussion (Misc queries) | |||
adding two colmuns together | Excel Discussion (Misc queries) | |||
Excel contact list-going from one row to mult. columns | Excel Discussion (Misc queries) |