Matching data

[John23785]

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

[#2]

@John23785 

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?

[#3]

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,

[#4 · Accepted solution]

@John23785 

See the attached version. It uses INDEX/MATCH

[#5]

That did it! Many thanks Hans. Appreciate it,