Forum Discussion
What formula returns the value of a cell but takes as parameters the output of another formula?
I am trying to return the value of a cell in the last row where data was entered into column B. I found a way to return the row number of the last row where column B was populated and I know that I ...
Courtesy If I understand you correctly, this would do it.
=INDEX(H:H,AGGREGATE(14,6,(ROW(B:B)*NOT(ISBLANK(B:B))),1),1)
It returns whatever is in H on the last populated row in B. In other words, if B10 is the last cell in B, it will give you the value of H10.