Check if a value exists in 2 columns and return true/false

[Daniboy7997]

I'm trying to make a formula that checks if a code exists in 2 existent columns, if it exists in BOTH, it returns a text, that part works perfectly, I used If, And, Match for it. But when i tried to get the other half, when it exists in only one of both (X-Or) it returns error, because of the Match function... help?

 

[Fluff]

Hi & welcome to MrExcel.
Is this what you mean

+Fluff 1.xlsm
	A	B	C	D
1
2	A	H	A	FALSE
3	B	I	I	TRUE
4	C	J	M	FALSE
5	D	K
6	E	L
7	F	M
8	G	N
9	H	O
10	I	P
11
Main

Cell Formulas
Range	Formula
D2:D4	D2	=AND(COUNTIFS(A:A,C2),COUNTIFS(B:B,C2))

 

[Daniboy7997]

Hey, thank you for the hospitality,

In the meantime of posting it and seeing your reply, I managed to get it done perfectly with IfError (My office is in portuguese, but i think its IfError) because of the condition of the match function returning error, and not a false or smth like that.

Thank you very much for the reply!

 

[Fluff]

Glad you sorted it & thanks for letting us know.