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?
Page 1 / 1
Hi
You would likely have to use the GSheet API to do that.
https://developers.google.com/sheets/api/guides/concepts

Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.