Comparing Data in Two Columns

[Supergirl]

I hope someone can lend a hand.

I need to compare the data in two columns - Columns A & B.

If the data in Column B also appears in Column A, regardless of its position in the column, then I want to highlight each instance of the duplicate value.

The data in Column A contains the same value two to three times so using the Conditional Formatting won't work.

The desired outcome can either be to highlight a field or add a statement like True in a new column.

Column A	Column B	Column C
Data 1	Data 2	Duplicate?
5	5	True
5	19	True
5	43	True
12	300	False
12	324	False
12		False
43		True
43		True
324		True
324		True

<tbody>
</tbody>

Any help would be greatly appreciated!
Jody

 

[mrshl9898]

For the TRUE/FALSE

=IFERROR(IF(LEN(VLOOKUP(A2,B:B,1,0))>0.1,TRUE,FALSE),FALSE)

 

[Fluff]

Another option
=ISNUMBER(MATCH(A2,B$2:B$6,0))

which can be used either in col C, or in conditional formatting