if data entered in a cell matches a range then execute google script

Viewed 51

I want to execute some code based on the entered value in a cell being in a named range.

I've tried something similar to this but it doesn't seem to be working:

function onEdit() {
    var aSheet = SpreadsheetApp.getActiveSheet();
    var aCell = aSheet.getActiveCell();
    var aColumn = aCell.getColumn();
    var aDatarange = aSheet.getRange(aCell.getRow(),aColumn);
    var aData = aDatarange.getValue();
    var SomeRange = aSheet.getRangeByName('RangeName');

    if (aData in 'SomeRange') {
        execute some code
    }
}

I'm guessing its the if statement I'm doing incorrectly but I've tried var in range and var = range and neither seem to work.

1 Answers
Related