At any given point of time a value from a specific column for eg: name will be compared between two sheets for a specified parameter for eg: Team size. The challenge though is that there should be a provision to select the first and second sheet in which the specific column and the specific parameter needs to be compared
The attached file has all the details. I will outline the logical flow of events
Step1: Select first sheet for comparison
Step2: Select second sheet for comparison (both these steps should be achieved through some automation and not manually)
Step3: Specify the value to be looked up. For eg: in this case, "Sam" from "name" column.
Step4: Specify the parameter to be compared for Sam. In this case, "Team size".
Step5: Value in first sheet for Sam-Text size to be returned
Step6: Value in second sheet for Sam-Text size to be returned
Step7: Compare the two values and say whether they match or do not match.