Forum Discussion
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 results where they might not be as I've tested a few entries with different dates and the result does not change. There are 2 entries that are required to match, name and floor #, and I've been using: If(OR(CountIF(Criteria1), (Criteria2)),IF(CountIF(Matching Criteria, True, False), Error). Any help would be appreciated, thank you
See the attached version. It uses INDEX/MATCH
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?
- 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,
See the attached version. It uses INDEX/MATCH
