Drop down menu problem

[adam0bmx0]

Right, i want to create a drop down box so that when you select one of the entries in it, it automatically loads up pre-determined data associated with what you've chosen.

For example the drop down box contains:

Balsa
PVC
Alu Honeycomb

Then when you pick one of these, below in the table it shows the values from another table for example:

density
shear modulus
tensile modulus

etc.

Does anyone know how to do that?

Thanks for any help.

Adam

[shg]

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

[adam0bmx0]

Edited, sorry for not reading any rules, I will do so when i have the time. Just i posted this as a last resort as i can't figure it out.

[EdMac]

The best way is to use a VLOOKUP function

I have attached an example of how this works.

Post back if you have any problems

[royUK]

Edited, sorry for not reading any rules, I will do so when i have the time. Just i posted this as a last resort as i can't figure it out.

It doesn't take many minutes to reads the rules, not a big price for free advice