Just find match and return same

Put this in B10:

=IF(ISNUMBER(MATCH($A10,B$1:B$6,0)),$A10,"")

Then copy down to A59.

Hope this helps.

Pete

Sorry, I got my col and row mixed up and confused you. Let me do it properly on the sheet, here goes...

Draw number B8:F8
Heading numbers: 1 to 49 from G7:SA7
I did try to use the formula you gave me by changing the cell ref but got it wrong.
Thx again

Okay, put this in G8:

=IF(ISNUMBER(MATCH(G$7,$B$8:$F$8,0)),G$7,"")

then copy across - probably to BC8.

Hope this helps.

Pete

Hi Pete

Thanx for that, does work but when copy down, it all goes funny, just need to remove or add the dollar sign somewhere really.
Anyway, I don't really know what I have done but works fine now. It just shows 1 when it matches instead of the actual number. It does what I want so thanks again.