How to get the address of the formula's result from 2D array (Matrix)

[cera22]

Hi everyone!

I have stumbled upon a problem while trying to extract the address of the formula's result. Namely, I am talking about the formula that calculated minimum value from the matrix based on the different criteria.

The matrix that I have created is simplified just for the purpose of this question.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]V. Criteria 1[/TD]
[TD]V. Criteria 2[/TD]
[TD]V. Criteria 3[/TD]
[/TR]
[TR]
[TD]H. Criteria 1[/TD]
[TD]22[/TD]
[TD]33[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]H. Criteria 2[/TD]
[TD]22[/TD]
[TD]33[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]H. Criteria 3[/TD]
[TD]25[/TD]
[TD]44[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]

**
If the "FORMULA" = 44, I would like to know the exact position of this result (the one bolded in the matrix)

So far I have tried CELL("address" but id doesn't seem to work because my formula is MIN(IF array formula.

I would appreciate any ideas or solutions.

 

[steve the fish]

You could do this:

=ADDRESS(MATCH(TRUE,INDEX($A$2:$A$4="H. Criteria 3",0),0)+ROW($A$2)-1,MATCH(TRUE,INDEX($B$1:$D$1="V. Criteria 2",0),0)+COLUMN($B$1)-1,4)

 

[cera22]

Thank you for the answer Steve.

My criteria is dynamic and it is changing with the user input. The result is calculated by the formula which is 1km long due to the complexity of the criteria.

This wont work because I need something where I can input my formula and its array and ask for the coordinates of its result. Even though there are similar values to the result I got, I will need the one that my formula returned and not a duplicate value somewhere in the matrix.

 

[steve the fish]

The only way to do that i think is to search for the result in the matrix. That isnt as bulletproof as using the formula conditions to build the address formula.