Find data from a column and see if it matches the concatenated equivalent to 3 columns

[tyrese215]

I have 3 columns with the following values:
A B C
1 8 2
2 5 4
3 2 6

In column F I have the following data with a separator of | between the values.
1 | 3 | 4
3 | 2 | 6

I want to find if the values column F are in the concatenated equivalent of each record in ABC above.

I know I could create a new column D and with the concatenated equivalent, and then just match the column F to Column d, but I need to compare the concatenated equivalent in ABC. If there is a match then return “YES” otherwise return “NO”

Thanks

 

[Special-K99]

1. So this is a match

A B C
1 8 2

against 1 | 8 | 2

but is this a match against 1 | 2 | 8 (same numbers different order) ?

2. Do you want to return Yes/No for each row in column F or just an overall if there is at least one match ?

 

[kvsrinivasamurthy]

IN F2 then drag down.

=IF(SUMPRODUCT(--(SUBSTITUTE(F2,"|","")=$A$2:$A$4&$B$2:$B$4&$C$2:$C$4))>0,"YES","NO")

 

[Special-K99]

=sumproduct((mid(f1,1,1)+0=a$1:a$3)*(mid(f1,5,1)+0=b$1:b$3)*(mid(f1,9,1)+0=c$1:c$3))