formula to check if Values in columns A or B or C exists in D or E or F

[aravindhan_31]

Hi,

Hope everyone is doing well! I need a small help in formula

I have values in Col A or B or & C like
30 Days, 60 Days , 15 Days etc. ( values will be in any one column always)

I have another set of values in Col D or E or F like
30 Days, 60 Days , 15 Days etc. ( values will be in any one column always)
I need a formula in Colum G to tell me if any of the values that was present in A or B or C are there in either D or E or F

refer the sample image.

Thanks for the help

Regards
Arvind

 

[Habtest]

Try this in G2 and drag down:

=CONCAT(A2:C2)=CONCAT(D2:F2)

 

[aravindhan_31]

T

Try this in G2 and drag down:

=CONCAT(A2:C2)=CONCAT(D2:F2)

Thanks Habtest..

so dumb I was.. just didnt think..

Regards
Arvind

 

[Habtest]

No problem

 

[jasonb75]

I need a formula in Colum G to tell me if any of the values that was present in A or B or C are there in either D or E or F

Are either of these situations possible? If yes then what result would be expected?

22.04.21.xlsx
	A	B	C	D	E	F	G	H
2	60 Days		30 Days	30 Days		60 Days	TRUE	FALSE
3	60 Days		30 Days	5 Days		60 Days	TRUE	FALSE
Sheet4

Cell Formulas
Range	Formula
G2:G3	G2	=SUMPRODUCT(COUNTIF(A2:C2,D2:F2))>0
H2:H3	H2	=CONCAT(A2:C2)=CONCAT(D2:F2)