I want for the entries from column A that are not in column C to show up in column E, in the same row as they were originally. I obtained code for a matching function from [Stack Overflow](http://stackoverflow.com/questions/33649310/whats-the-best-way-to-compare-two-columns-of-data-in-google-sheets-and-output-o), stated below. It also looks at columns A and C, and the ones from column A that are not in column C will show up in E. However, they are shown consecutively, not on the same row. function onOpen() { SpreadsheetApp.getUi().createMenu("CD Report") .addItem("Agreement Report", "agreementReport") .addToUi(); } function agreementReport(){ var as = SpreadsheetApp.getActive(); var sheet = as.getSheetByName("15-16 1:1 agreement"); var handedIn = sheet.getSheetValues(2, 1, sheet.getLastRow(), 1); var stuNames = sheet.getSheetValues(2, 3, sheet.getLastRow(), 1); var list = []; for (i in stuNames){ var curName = stuNames[i][0]; var exists = false; for (j in handedIn){ var curCheck = handedIn[j][0]; if (curCheck == curName){ exists = true; break; } } // end for j if (exists == false){ list.push([curName]); } } // end for i sheet.getRange(2, 5, list.length, 1).setValues(list); } // end agreementReport