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.