Multiple table merge with multiple column condition

[Anonymous]

Hi,

I would like to merge two table but i need to look at mutile column to see if I have a match.

the goal is to find if there is a match in the column IP1 then IP2,IP3... in each of the other table IP column.

and if possible add plus one on the number of matches 

table 1:

Name | IP1 | IP2 | IP3 | IP4 | IP5

table 2:

Depatement | IP1 | IP2 | IP3 | IP4 | IP5

merge table:

Name| Depatement | IP1 | IP2 | IP3 | IP4 | IP5| Number of matches 

Do you have any idea now I can proceed in Power Query?

Thank you very much

[edhans · Accepted solution]

You can merge in Power Query on multiple fields. Just CTRL-Click the 2nd-Nth fields on both tables in the same order. Little numbers will show up to show you which columns will join based on which.