find and copy data from column

[akdeuce]

I have a long list of data imported into one column. Each record is 13
rows. I would like to be able to type the first line of any record
into cell B1 and have it find and report the record plus 12 rows
beneath the record into C1:C13. Any suggestions?

 

[JE McGimpsey]

I have a long list of data imported into one column. Each record is 13
rows. I would like to be able to type the first line of any record
into cell B1 and have it find and report the record plus 12 rows
beneath the record into C1:C13. Any suggestions?

One way:

C1: =B1
C2: =INDEX(A:A, MATCH($B$1, A:A, FALSE) + ROW() - 1)

Copy C2 down to C13.

 

[akdeuce]

That's exactly what I was looking for! Thanks!