compare two colums; if item in one is in the other return true

[inosent]

i have 2 columns of data

abc lmn
def opw
ghi rst
xyz abc


in a third column i want to see if an item in col 1 is in col 2, and if it is, say TRUE


for example

abc lmn TRUE
def opw FALSE
ghi rst FALSE
xyz abc FALSE



what is the best way to go about this?

 

[cgcamal]

Hi,

Try with:

Excel Workbook
	A	B	C
1	abc	lmn	TRUE
2	def	opw	FALSE
3	ghi	rst	FALSE
4	xyz	abc	FALSE
...

Enter formula in C1 and copy down:

Cell Formulas
Range	Formula
C1	=IF(IFERROR(MATCH(A1,$B$1:$B$4,0),FALSE),TRUE)

Hope this helps,

Regards.

 

[barry houdini]

Try this formula in C1 copied down

=COUNTIF(B:B,A1)>0