Link to home
Start Free TrialLog in
Avatar of Go-Bruins
Go-Bruins

asked on

Google sheets script to grab contents of cell two columns to left?

Hi all,

I've written a simple script that grabs the contents of the active cell and assigns it to a var here:

var valueactivecell = activecell.getValue();

I'd also like to grab the contents of a cell that's two columns to the left and one row up. So for example , if the active cell is C2, the cell i'm interested would be in address A1.

How do I achieve this?

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Go-Bruins
Go-Bruins

ASKER

Awesome. Thank you.