Fill a table cell with data from another table based on the adjacent table cell value

Hi Community members, I am compiling a spreadsheet to list the department meeting schedule for the year, retain records of past meetings, and record statistics for meeting presenters. Sheet "DC-80 ...