Forum Discussion
Comparing worksheets
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.
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.
