Forum Discussion
John23785
Jun 14, 2024Copper Contributor
Matching data
Hello - I am trying to check data across just 2 Tabs to see if the dates match but the problem I am running into is the report is the same but the entries are not lining up so I am getting all True r...
- Jun 17, 2024
See the attached version. It uses INDEX/MATCH
HansVogelaar
Jun 14, 2024MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
John23785
Jun 17, 2024Copper Contributor
Apologies on the delay but I've attached an example, it's not working on my main file as there are more entries in the new version than the old so running into some issues. Any tips would be much appreciated,
- HansVogelaarJun 17, 2024MVP
See the attached version. It uses INDEX/MATCH
- John23785Jun 17, 2024Copper ContributorThat did it! Many thanks Hans. Appreciate it,