create a list that places data in 3 colmuns (cells) from mult row/

[old fellow]

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

 

[Ken Johnson]

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 inthe
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 threecells  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(D2022,MATCH($J$11,$G$20:$G$22,FALSE))

and fill it across to I11.

Ken Johnson