Search for number on one sheet, return ref number on a different sheet

[dwrowe001]

Hi,
Need help again with another formula.. this one is kinda complicated..

I have SHEET A Below:

Ref numbers in column A, 1 thru 75
numbers to be searched in columns B thru BT, every other row,

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	ALL THE WAY TO BT
1	1	45	34	55	50	45	23	19	22	67	89	0	0	0
2
3	2	56	23	28	45	51	52	77	61	0	0	0
4
5	3	0	0	0	0	0	0	0	0
6
7	4	75	88	73	24	30	45	0	0	0	0
8
9	5	94
10
11	6
12
13	7

<tbody>
</tbody>

I need a formula which will be on SHEET B, to search the numbers in Columns B thru BT, every other row, 1 thru X ( I have Ref numbers 1 thru 75).. then return the Ref number from Column A in the row where the search number was found.

So say I was looking for the number 45, the formula should return Ref numbers 1,1,2,4... If possible I would like the returned numbers to appear in one Cell on a different sheet (SHEET B) separated by a comma..

Thank you for the help!!

 

[mart37]

=IFERROR(INDEX('[Last5Ball1]Last 5 Ball 1'!$M4:$BT$178,SUMPRODUCT((LARGE(($A1='[Last5Ball1]Last 5 Ball 1'!$M$4:$BT$178)*ROW($1:$175),COLUMN()-1)))),"")

When you closed Last5Ball1.xlsx then you see in the formula the complete path.
Maybe there is a mistake.
With rows() you refer to all numbers in the range from M4:BT178 = 175