Find given value and returns the highest sale number, column reference

[vladi305]

I have a tab with some data and I need to get information from that tab
I needto find a given value and returns the highest sale number, column and row reference.
Once that value is found I need to return the column reference or in which column is found
1st, 2nd, 3rd. 4th or 5th
FYI: this sheet has formulas in it

 

[lrobbo314]

Like this?

EXCEL
	A	B	C	D	E	F	G	H	I
1								Find:	12
2								Result:	Row: 12 Column: 3 Max: 52 Header: 3rd
3
4		1st	2nd	3rd	4th	5th
5	1	33	44	21	36	0
6	2	76	51	46	32	0
7	3	0	0	0	0	0
8	4	0	27	0	0	0
9	5	0	0	0	31	0
10	6	0	0	29	0	0
11	7	27	0	0	0	0
12	8	0	0	0	0	0
13	9	0	0	26	0	0
14	10	0	0	0	0	0
15	11	0	31	0	0	0
16	12	0	36	52	41	0
17	13	0	0	0	0	0
18	14	0	0	0	29	55
19	15	0	0	0	32	0
20	16	0	32	26	50	0
21	17	0	0	0	0	0
22	18	0	0	0	0	0
23	19	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
I2	I2	=LET(d,B5:F23,ro,XMATCH(I1,A5#,0),rd,INDEX(d,ro,0),mx,MAX(rd),col,XMATCH(mx,rd,0),hd,INDEX(B4:F4,col),TEXTJOIN(CHAR(10),,"Row: " & ro,"Column: "& col,"Max: "&mx,"Header: " & hd))
A5:A23	A5	=SEQUENCE(19)
Dynamic array formulas.

 

[vladi305]

Like this?

EXCEL
	A	B	C	D	E	F	G	H	I
1								Find:	12
2								Result:	Row: 12 Column: 3 Max: 52 Header: 3rd
3
4		1st	2nd	3rd	4th	5th
5	1	33	44	21	36	0
6	2	76	51	46	32	0
7	3	0	0	0	0	0
8	4	0	27	0	0	0
9	5	0	0	0	31	0
10	6	0	0	29	0	0
11	7	27	0	0	0	0
12	8	0	0	0	0	0
13	9	0	0	26	0	0
14	10	0	0	0	0	0
15	11	0	31	0	0	0
16	12	0	36	52	41	0
17	13	0	0	0	0	0
18	14	0	0	0	29	55
19	15	0	0	0	32	0
20	16	0	32	26	50	0
21	17	0	0	0	0	0
22	18	0	0	0	0	0
23	19	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
I2	I2	=LET(d,B5:F23,ro,XMATCH(I1,A5#,0),rd,INDEX(d,ro,0),mx,MAX(rd),col,XMATCH(mx,rd,0),hd,INDEX(B4:F4,col),TEXTJOIN(CHAR(10),,"Row: " & ro,"Column: "& col,"Max: "&mx,"Header: " & hd))
A5:A23	A5	=SEQUENCE(19)
Dynamic array formulas.

Yes, exactly that is what I'm looking for