Find column, then copy a dozen cells from it?

[John.McLaughlin]

Trying to improve my pack list.

Our worksheet has a unique product number at the top of each column. The cells of each column contain description, weight, size, price, etc.

I want to copy the contents of the column (approx 8- 10 rows each) onto a packing list.

Currently I find the column with index/match, and just show the description on the pack list. How can I also include the additional details about the product?

Thanks in advance!

 

[offthelip]

if your top row has an index and match such as this:
=INDEX(B6:Q6,0,MATCH(B$1,B$5:Q$5,0))
you can then just copy it down, provided you have put the $ signs in to ensure the match is alway doen on the description
so the next line is:
=INDEX(B7:Q7,0,MATCH(B$1,B$5:Q$5,0))

 

[John.McLaughlin]

brilliant! it never occurred to me to repeat the match, I was looking to copy a range. thank you!