Comparing outcomes using a unique ID

Hello,

I have 2 different spreadsheets with unique Appointment IDs in one row that match an appointment outcome - ie. Cancelled appt/tested/medical referral in another row

Using the Appointment ID, I want to compare the2 spreadsheets to make sure the appointment outcome is the same for both spreadsheet.