In sheet 1, Column A has data (last row that has data is 15)
Sheet 1, Column B has data (last row that has data is 55)
In sheet 2, column A I would like the text thats in the last row from sheet 1 to show
and same thing for column b
This formula works =LOOKUP(2,1/(A:A<>""),A:A)
But its only for that sheet. How do I get that formula to get data from sheet 1, but show on sheet 2.
Thanks
Bookmarks