Result based upon a list

[markswan20]

Hi everyone,

This is my first post i have had a look for a possible solution but i'm unable to find one and would really appreciate some help.

I have an excel spreadsheet that im trying to create a drop down box where i can select a different type of material i;e 0.7mm steel 1.2mm steel 1.5mm steel etc. I can do this but i need the material weight to appear in a specific box. Is this possible and if so how can i do this.

Thank you very much

Mark


http://www.kidderminsterwebdesign.net

[jasoncw]

Is this a drop-down list you created using data validation, or is it a ComboBox? If it is a combo box, right-click and view Properties. There is a property called Linked Cell. Type in the cell reference you would like to populate.

If it is a data validation, just go to the cell which you would like to populate, and reference to the cell with the drop-down list in it (e.g. =A1).

[EdMac]

Hi Mark,

Your question is not that clear but it sounds like you need to use VLOOKUP using the value from the dropdown to look up the weight.

Post back if that is not the problem and give some more detail of what you need.

Ed

[daddylonglegs]

hello mark,

I'd say you need vlookup.

Say your dropdown is in A1 and you want the corresponding weight to appear in B1.

List all the options from the dropdown somewhere (or use your current list if you have one) , e.g. in Y2:Y10 and then list the corresponding weights in Z2:Z10.

Then in B1 you just use the formula

=VLOOKUP(A1,Y2:Z10,2,0)