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 ...
you could use INDIRECT for this. Be careful though, it's a volatile function, and if overused can become quite taxing on CPU. It would look like
=INDIRECT("B"&[your function that returns row number])