You're welcome, Kevin - thanks for feeding back.

Pete

On Jan 9, 4:27*pm, Kevin Mulvaney
wrote:
Thanks that works perfectly!!!

Kevin



"Pete_UK" wrote:
Put this formula in column D of your info sheet:

=B1&"_"&COUNTIF(B$1:B1,B1)

and then copy this down - it will give you a sequential reference
number for each value in column B.

Then in your summary sheet you can put this formula in A1:

=INDEX(Info!$C:$C,MATCH("pdx_"&COLUMN(A1),Info!$D: $D,0))

and this one in A2:

=INDEX(Info!$C:$C,MATCH("cor_"&COLUMN(A1),Info!$D: $D,0))

and then you can copy these across until you get #N/A errors. If you
want to avoid these then you can use:

A1: * =IF(ISNA(MATCH("pdx_"&COLUMN(A1),Info!$D:$D,0)),"" ,INDEX(Info!$C:
$C,MATCH("pdx_"&COLUMN(A1),Info!$D:$D,0)))

and similar for A2 but changing "pdx" to "cor". Then copy them across
as far as you wish.

Hope this helps.

Pete- Hide quoted text -

- Show quoted text -