index-match

I'm building a pseudo-app in Google Sheets to allow managers to tell me the status of an employee on their team. Please note: I'm very much a beginner at Google Apps Script, .css and .html, and have been cobbling bits…