Skip to main content

Im wanting to lookup a specific row that is the 3rd row up from the last row in a google sheet. So for example, if the last value input into a row is in row 10, I want to look up what the data is that is 3 rows up from this, so in row 7, in a specific column. Is this possible?

Hi @markemaly 

You would likely have to use the GSheet API to do that.

https://developers.google.com/sheets/api/guides/concepts

 


Reply