Matching Data across Multiple-Column combinations

[LearningExcelFormula]

File_1
USER ROLE START_DATE
A R1 01.01.2022
A R2 02.01.2022
B R4 01.01.2022
A R3 03.01.2022
C R1 01.01.2022

File_2
USER ROLE START_DATE
A R1 01.01.2022
D R2 02.01.2022
B R4 01.01.2022
F R3 03.01.2022
C R1 01.01.2022

Objective is match the data across all column e.g.
first row of File_1: User 'A' assigned Role 'R1' with START_DATE '01.01.2022' - if this combination is present in File_2?

[ELeGault]

Add a "Helper Column" to your data sets. CONCATENATE(A:C) or however many you need to tie together. Then use this to lookup/compare and aggregate your data sets

[LearningExcelFormula]

Thanks for your response, I am currently using the CONCATENATE in both files and then VLOOKUP; but it is a two-step process. Is there anyway I can use MATCH or some other function to make it one-step/easier process.

[ELeGault]

Is it a Many:1 Lookup?

Can you build out a sample file of what you are actually doing so we dont get hung up on crafty ways around a function that may not be what is needed.