Just find match and return same

Hi

Very simple one, its to do with lottery drawn numbers. B1:B6 are the drawn numbers and A10:A59 are heading number 1 to 49. When draw is out, the relevant number will appear under its relevant heading number.

Thx

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.