pulldown lists - how to populate data

**lkb3** · 05-28-2008, 09:34 AM

I have three columns of values - the name of a material, and two physical properties - strength & modulus.

example:
Steel, 36000, 3000
Nylon, 16000, 410
ABS, 5000, 500
etc.

I have three cells:
The first is the pulldown list, where the user chooses what the material is, which I have working fine

The second is the strength value, the third is the modulus. When the user picks the pulldown list, I want these to cells to pull the correct value from the respective lists.
So, if the user chooses "Nylon" the second value in the materials list, how do I get cell 2 to grab the value 16000, the second value in the strength list?

Thank you.

**arthurbr** · 05-28-2008, 09:56 AM

Originally Posted by lkb3

I have three columns of values - the name of a material, and two physical properties - strength & modulus.

example:
Steel, 36000, 3000
Nylon, 16000, 410
ABS, 5000, 500
etc.

I have three cells:
The first is the pulldown list, where the user chooses what the material is, which I have working fine

The second is the strength value, the third is the modulus. When the user picks the pulldown list, I want these to cells to pull the correct value from the respective lists.
So, if the user chooses "Nylon" the second value in the materials list, how do I get cell 2 to grab the value 16000, the second value in the strength list?

Thank you.

hi and welcome to the board
If your validation is in cell A1 and your table in range say g1:i3, in A2 use =Vlookup(A1;$G1:$I$3;2) to retrieve the strength.
Same method for moudulus in A3
Cheers