Hello,
I am trying to find the cell location/address of a value in a large array. The formula below returns the value in that cell (40) but I would like to return its address ($E$3). How would I go about doing that?
=HLOOKUP(WaterFalls!C4,'Calcs&fixed data for plots'!D2:BE23,2,FALSE)
I am trying to find the cell location/address of a value in a large array. The formula below returns the value in that cell (40) but I would like to return its address ($E$3). How would I go about doing that?
=HLOOKUP(WaterFalls!C4,'Calcs&fixed data for plots'!D2:BE23,2,FALSE)