Joining numbers with multiple criteria fields

[Floris77]

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 solution]

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.

[Floris77]

Hi,

Yes, Join was the solution; I just missed out that you can select more than one matching fields.

thanks.