Comparing outcomes using a unique ID

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
use Vlookup