Hi,

I have a question that has caused me big confusion in my Excel files. I need to update one of my tabs in this excel sheet so that it can read from a dropdown list. Below is the example on how I want it.

Sheet 2, I have an issue note for stock that I need to fill out with ammounts so that I can send as an email attachment once a week or daily.

The stock names of this issue are selected from an already created drop-down list
Ex: item1, item2, item3 all in a dropdown list and you can select these dropdowns of these names in cells D6 to cell D18.

Now in cell H6 to H18, the ammount of items need to be written down for the item selected from the drop down list.

Ex: item1 (from dropdown in cell D6) 400 (written in cell H6)
item2 (from dropdown in cell D7) 100 (written in cell H7)
item3 (from dropdown in cell D8) 5 (written in cell H8)

When these items are selected and updated with the ammounts needed, it is sent by email for ordering on that particular date.

In sheet 1 on same excel file, I have a list of the stock items same as items in dropdown list on cells A2 to A4 (not as a dropdown list).
Ex: item1(A2)
item2(A3)
item3(A4)

Now, here is the trouble I'm having. I need a sort of a formula or something that automatically writes down the ammount written on sheet 2 on cells H6 to H18 (in this example, 400, 100 and the 5) to their respective item in sheet 1 and the column of that particular date.

Ex: item1(A2) 400(B2)
item2(A3) 100(C3)
item3(A8) 5(E8)