Transfering a list of data based on a list selection

I'm trying to create a spreadsheet where the user first selects a product by name in a drop down menu (something I've learned how to do) When the product is selected I want a column of numerical data specific to that product to be transfered from somewhere on the worksheet to a specific area where it can be included in calculations. When a different product is selected, specific data for that product will replace the data of the previous, and so on... I've been trying off and on for a couple days to find out how to make this happen, I'm clearly no guru and would love some help, thanks

SMIPRODUCTTEST.xls

hopefully attachement works. When a name is selected in the yellow list (for instance "FUJITSU12K" I want the column of data specific to that model to be transfered or pasted int G7:G10 where it is then summed in G11. hope that helps, thanks

Try the following.

copy the formula =HLOOKUP($D$7,$D$16:$I$20,2,0) in G7 Cell
copy the formula =HLOOKUP($D$7,$D$16:$I$20,3,0) in G8 Cell
copy the formula =HLOOKUP($D$7,$D$16:$I$20,4,0) in G9 Cell
copy the formula =HLOOKUP($D$7,$D$16:$I$20,5,0) in G10 Cell

Hope this solves your problem.

that worked perfectly, thank you so much

you are welcome.

another, a little more dynamic, way...

Hi Smirish,

If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon).

Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

Thanks.