Forum Discussion

rt2963's avatar
rt2963
Copper Contributor
Jan 19, 2025

Returning a cell reference.

I've searched through all the Excel functions and can't seem to find a way to return a cell reference from a formula if that makes sense. 

For example. I have 5 in cell A1, 10 in cell A2, 4 in cell A3 and 8 in cell A4.

In another cell I have the formula MAX(a1:a4) and that will return 10 which is the largest number in the array. I would like to know if there is a function I can use to return the reference of the cell instead of the value so that the formula would return $A$2 or whichever cell contained the largest value in the array. 

Resources