I'm trying to use a formula to grab the row of a value. I've figure out how to do this, but I'm unable to use this value to reference a cell. For example I know the value I want is in cell "=A4", but when I try to use my formula of =$A$FORMULA I get an error message. of an invalid formula. My formula works and returns 4, but I'm struggling to figure out how to make the 4 my formula returns function the same as the formula "=A4".
My Formula is "=CELL("row",INDEX(H2:H11,MATCH(MAX(H2:H11),H2:H11,0)))" which returns 4. I want to be able to do something like "=$A$CELL("row",INDEX(H2:H11,MATCH(MAX(H2:H11),H2:H11,0)))" and have it function the same as "=A4". I think it's a matter of conversion with the result of my formula, but I'm not having much luck with getting it to perform the way I'm expecting it to. I could write a long complicated IFELSE, but I think there should be a shorter solution to this.
Basically I'm wondering how to get something such as "=A(4)" to function the same as "=A4".
I haven't had much luck with google so far, but I may just not be searching the write terms. Any help understanding how this works would be appreciated!
P.S. if Needed/Preferred I can provide screenshots of the excel formula I am using.
Bookmarks