Copy info in a range that always changes.

[j. martinez]

I have the following list

row 9 piece 1 12x12x12 $$$
row 10piece 2 12x24x12 $$$

Row 15 total material $$$

This list can have a various amounts of entrys so "total material" will not
always be Row 15 (piece 1 will always be row 9) and I would like to know if
there is a way to tell excel to Find what Row "total Material" is in and copy
Range ("9:"total Material" row)

Thanks in advance

 

[mcarrington]

Have you tried using the vlookup function?