Joining numbers with multiple criteria fields

Question

Hi, Im struggling with a problem for which I thought the solution might be quite easy.. However haven't found it, so I'm trying this great medium again..

Situation:

I have 2 different data sheets.

The first contains 4 columns

Name of playlist

Name of song

Nr of plays

Date

The seconds contains these columns

Name of playlist

Name of song

Position

Date

So, the obvious question is; How can I add the Position to the first sheet. Therefor it has to match both Name of the playlist, Name of the song and the Date.

I tried the Join en Union function here, but it looks like it fails to match with multiple criteria.

Thanks again for your help.

Best

JohnJPS · Accepted Answer

Join does seem appropriate for this. Could you provide sample data where you would expect a match but aren't getting one?

Lacking that, a wild guess might be different date formats in the two files.