Show information after product is selected from drop down menu

[Bouda 3964]

Hello!

I am trying to figure out how I can put product data in one big sheet, then select a product on a different sheet and automatically get all the information about the product.

I have made an example to clarify:
I have three different boxes. Different size, weight and cost. A customer wants 23 boxes of box 1, 93 boxes of box 2 and 2 boxes of box 3. I want to select the box type manually (from a drop down menu) and enter the quantity manually. At the bottom I want to see the total weight and costs.

Creating the drop down menu was easy. In order to get the rest of the data I used INDEX(Array;row;column). I think I got the array and the column right but the row seems to be tricky. I want the row to be dependent on the product I select in the drop down menu to get the proper information. For some reason it works when I select the blank cell, but not when I select a named cell? It also selects the wrong row, it should be one row below the one it selects. I have tried adding +1 but it doesn't seem to work.

Help will be much appreciated! I have tried googling for almost an hour now.

I have attached my example file.

[modytrane]

Formula in L28:

Formula in M28:

[wyowhite]

use the match function to select the row #.
in L27 =INDEX($A$3:$F$8,MATCH($J27,$A$3:$A$8,0),COLUMN(E1))
pull over and down to complete the matrix.

[Bouda 3964]

Thanks! The match was just what I needed. Much appreciated.