Myujth

I have written a script that sends a slack message/email whenever a Cell is updated. I am at a standstill though. I want to find the match of the edited cell (in the "Offense Log" sheet) in the "Data Tracking" sheet. Once finding that match in "Data Tracking" then get the value of column N in that row. For example, the next available row in "Offense Log" is filled out. Column C contains the employee name. I want to find that same employee name in the "Data Tracking" sheet, then get the value of column N in that row - which is their attendance points.

All in all, whenever someone is entered into the "Offense Log" sheet I want my slack message/email to tell me how many attendance points they have now after the edit. My send to slack/email is functioning properly, so I just need help with the matching portion:

function checkValue(e){

 var ss = SpreadsheetApp.getActive();
 var offensesheet = ss.getSheetByName("Offense Log 2.0");
 var activerow = offensesheet.getActiveRange().getRow();
 var name = e.range.getValue();
 var rangeEdit = e.range.getA1Notation();

 if(rangeEdit[0] == "C")

Here is the link to the spreadsheet for example: https://docs.google.com/spreadsheets/d/1k1kp5tynkS7uZ8_H9hGC4v-C_dFaE0f0sQNvMz585g0/edit#gid=1477981686