Compare Cell A to see if value is either in one column or both

[topswim]

I am to looking at value in A column and see if it's in only column B, but not in column C. If it's true (in column B only) then I want to enter cell A value in column D otherwise blank

A B C D (desired result from above)

Tre	rtp	plr	Tre
plr	plr	plr	blank
oki	tre	oki	oki
lpo	mng	fre	blank

 

[Fluff]

Why do you have oki in col D as it exists in col C but not in B, which is the opposite of what you said.

 

[JamesCanale]

I have the impression from the desired results, that you want an exclusive OR, that is, it's good if it's in column B or column C, but not both or neither.

MrExcelPlayground4.xlsx
	A	B	C	D
1	tre	rtp	plr	tre
2	plr	plr	plr
3	oki	tre	oki	oki
4	lpo	mng	fre
Sheet23

Cell Formulas
Range	Formula
D1:D4	D1	=IF(XOR(OR(NOT(ISERROR(MATCH($B$1:$B$4,A1,0)))),OR(NOT(ISERROR(MATCH($C$1:$C$4,A1,0))))),A1,"")

 

[Joe4]

If what you said is true, and you just have an error in your example, and "oki" should NOT show up, then if your data begins in row 1, place this in cell D1 and copy down for all rows:

=IF(AND(COUNTIF(B:B,A1)>0,COUNTIF(C:C,A1)=0),A1,"")

 

[JEC]

or

=IF(CONCAT(--(A1=B1:C1))="10",A1,"")

 

[Fluff]

If you want one or the other but not both

+Fluff 1.xlsm
	A	B	C	D
1
2	Tre	rtp	plr	Tre
3	plr	plr	plr
4	oki	tre	oki	oki
5	lpo	mng	fre
Main

Cell Formulas
Range	Formula
D2:D5	D2	=IF(XOR(COUNTIFS($B$2:$B$5,A2),COUNTIFS($C$2:$C$5,A2)),A2,"")

 

[Fluff]

@JEC have you actually tried that? As it will just return blank for each row.

 

[JEC]

if it's in only column B, but not in column C. If it's true (in column B only) then I want to enter cell A value in column D otherwise blank

I actually don't see how these examples fit the question

How is D2 "Tre"

 

[Fluff]

Because

it's in only column B, but not in column C

 

[JEC]

I compared per row Thats why,time to sleep