how to match on multiple columns

Hello @ARiffe,

What you are asking seems to be something that is not too difficult to do with R. However, it is a bit difficult to tell you exactly what to do since your question does not contain any "reproducible example". In a few words, a reproducible example is one that contains a sample dataset that has all the features you described (it needs not be your actual dataset in case you cannot share due to professional reasons for example) and also the code that you tried, which did not work. I understand that you may not have tried any code and that you are seeking for help. If you could provide sample data (2 datasets in your case), that would help us to help you :slight_smile:. By the way, you may want to look into the dput() function in order to share your data with us. If your data is too big, then subset if by a few rows before sharing:

dput(mydata[1:50, ])

This great article here will provide more information on what a reproducible example is: FAQ: How to do a minimal reproducible example ( reprex ) for beginners