I am trying to compare two excel sheet that have thousands of data. I would like to know how can these be compared quickly without using for each row activity
Sheet 1 has two columns: Id and Source Value.
Sheet 2 has two columns: Id and Target value
I want an output in sheet 3 with the columns Id, Source value, Target value and status
For each Id, it should populate corresponding source value from sheet 1 and target value from sheet 2 and update status as ‘Pass’ if source and target value matches or update as ‘Fail’