javascript - Find a value in a cell, select/activate another column -

i have trouble google script.

i have spreadsheet unique values in column. need find value stored in variable. activate cell, move 2 columns right , copy value of cell or store value variable.

is possible in google sheet?

one of codes tried:

    function slett() {       var slett = 4; //define value of variable i'm searching       var ss = spreadsheetapp.getactivespreadsheet();       var s = ss.getsheetbyname('ark 1'); // name of spreadsheet       var values = s.getdatarange().getvalues();       (var row in values) // in each row         if (values[row][1] == slett){  //if value in column b matches 'slett'....                                          // activate finding                                          // move righet using offset                                          // store value of cell in variable            s.deleterow(parseint(row)+1);  // delete row             break;                        // not search instance of 'slett'     }     }; 

i know how move, can't figure out how activate cell 'slett'-value.

if understand correctly, want search down column b value slett (4 in case), , once find it, store value in column d of same row. easy since have stored values of entire sheet:

if(values[row][1] == slett){   var storevariable = values[row][3];   s.deleterow(parseint(row)+1);   break; } 

you need access sheet again if needed additional data sheet or write it. example, if had grabbed values in column b instead of entire data range, do

var storevariable = s.getrange(row+1,4).getvalue() 

to value 2 columns on found slett.