Forum Discussion
Solved
Comparing worksheets
I am trying to create a formula to compare two worksheets and find differences.
The following formula appears to work but the results are incorrect. What am I doing wrong?
=MATCH('Rail Operations'!$D4,'Rail Ops Extract'!$D$2:$D$533,0)
Your formula returns the expected results in my sheet. Can you add screenshots of your sheets which show the formula, data and results?
For simplification the example matches data within one sheet. The results are the same when referring to the "Rail" sheets.
2 Replies
Your formula returns the expected results in my sheet. Can you add screenshots of your sheets which show the formula, data and results?
For simplification the example matches data within one sheet. The results are the same when referring to the "Rail" sheets.
Thanks for responding. Turns out the problem was not with the formula but with the interpreter of the results i.e. me 🙂
I assumed that the number for a Match was the actual row number in the sheet, not the relative row number. Definitely My Bad.
