How do I update the formula below to give me the desired result in example 4 with finding the matching values as it does with examples 1,2,and 3:
Example 4:
if df8:dh8=345 and
if df7:dh7=234 then
di7=3,4 (because df8=dg7 and dg8=dh7) this is the desired result
but the formula did not yield any matches in this case
The formula below works for the following example:
=SUBSTITUTE(SUBSTITUTE(IF(DF7=DF8,DF7," ")&","&IF(DG7=DG8,DG7," ")&","&IF(DH7=DH8,DH7," "),", ","")," ,","")
example1
if df8:dh8=124 and
if df7:dh7=125 then
di7=1,2 (because df8=df7 and dg8=dg7
example2
if df8:dh8=125 and
if df7:dh7=135 then
di7=1,5 (because df8=df7 and dh8=dh7
example3
if df8:dh8=115 and
if df7:dh7=134 then
di7=1 (because df8=df7
Example 4:
if df8:dh8=345 and
if df7:dh7=234 then
di7=3,4 (because df8=dg7 and dg8=dh7) this is the desired result
but the formula did not yield any matches in this case
The formula below works for the following example:
=SUBSTITUTE(SUBSTITUTE(IF(DF7=DF8,DF7," ")&","&IF(DG7=DG8,DG7," ")&","&IF(DH7=DH8,DH7," "),", ","")," ,","")
example1
if df8:dh8=124 and
if df7:dh7=125 then
di7=1,2 (because df8=df7 and dg8=dg7
example2
if df8:dh8=125 and
if df7:dh7=135 then
di7=1,5 (because df8=df7 and dh8=dh7
example3
if df8:dh8=115 and
if df7:dh7=134 then
di7=1 (because df8=df7