Count set of comma separated values within another paired columns

Hi Experts,

I would like to count set of comma separated values from another table.

For example, AF17=2,0,2 so i want to check/count this paired/set value within another paired/joined columns of 3,4,7=AD17.

The below mentioned formula is working fine if there is a single value in column AD & AF, but i need a formula to get the results based on a comma separated range & pairs please.

=COUNTIFS(OFFSET(A:A,0,AD6-1),AF6,A:A,"y")

I have attached the sample file. Thanks in advance.