I am about to ad frequently rows to a google spreadsheet. The rows are added at the bottom.
I want to return the value for example column A and search for the recently added value at the bottom and return/Copy this to a different spreadsheet.
How do i use the lookup method the right way?