VLookup on Javascript #2

Guntar Susatyo

The code first opens the spreadsheet with the ID '1pEGVc2q32yRCYhPxcl_xHwBfoI_ApgizkpX_4ngorzg' and then iterates through the data in the 'PO' sheet. For each value in the data range D:D, it checks to see if the value in column B is the same as the code dataKodePOD. If it is, the function returns the value of i+1. If the values in column B are not the same, the function logs a message to the logger and returns the value of i+1.

Shortcut: sheetVLookUp_02

function barisDataPO(dataKodePOD) {
  const sheetDataPO = SpreadsheetApp.openById('1pEGVc2q32yRCYhPxcl_xHwBfoI_ApgizkpX_4ngorzg').getSheetByName('PO');
  const dataDicari = sheetDataPO.getDataRange('D:D').getValues();
  for(var i = 0; i < dataDicari.length;i++){
    if(dataDicari[i][0] === dataKodePOD){ //[1] because column B
      Logger.log((i+1) + ' ketemu baris ke-nya !')
      return i+1;
    }
  }
}