Find the row and column value of a cell reffering a table

Table contains numbers , as follows: (example) and table named as "sales"
A1=10 B1=15 C1=50
A2=2 B2=5 C2=7
A3=30 B3=20 C3=11
A4=4 B4=3 C4=25

D1=max(a1,c4) formula result is=50

on E1 cell, I want to find D1 value in which row and which column on the table"sales"

I know that result should be Row=1 column=3.

Which formula can show row and column value in E1 cell.(Not VBA but only formula)

Thanks in advance for reply.

Great!
Thanks for prompt reply.
Best wishes, regards.

Thanks a lot.
Regards

Originally Posted by Tony Valko

Try this...

Data Range

	A	B	C	D	E
1	10	15	50	50	R1 C3
2	2	5	7
3	30	20	11
4	4	3	25

This array formula** entered in E1:

="R"&MAX(IF(Sales=D1,ROW(Sales)))-MIN(ROW(Sales))+1&" C"&MAX(IF(Sales=D1,COLUMN(Sales)))-MIN(COLUMN(Sales))+1

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

I assume you want the row and column RELATIVE to the data range.

Also, assume there will not be duplicate max values.