Using ISERROR and Match to find match in multiple columns

[Larsschr]

Hi!

I'm using ISERROR and MATCH to see if a combination of two cells is the right connection according to a "master sheet".

However the one of these values can be found in two columns. The formula I'm using right now is:

=ISERROR(MATCH(1;($D2='Overzicht AM & PV'!$H:$H)*($N2='Overzicht AM & PV'!$J:$J);0))

The first part: ($D2='Overzicht AM & PV'!$H:$H) is correct since the value can be found in one column and can be matched.

The second part : ($N2='Overzicht AM & PV'!$J:$J) however is not.

This is because $N2 can be found in the column J or K and not only J.

How can I adjust this formula to work correctly?

Thanks!