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 ...