Maybe I don't understand well enough, but it looks to me like this would work
(change ranges if necessary)
in first cell in K:
=COUNTIF($J$2:$J$457,D2)0
That will give you TRUE if value in D2 appears anywhere in J2:J456
in first cell in L:
=COUNTIF($D$2:$D$457,J2)0
again, if value in J2 appears anywhere in D2:D457, will return TRUE
finally in first cell in L:
=OR(K2,L2)
Will return TRUE if only K2 is True or only L2 is true or both are True: it
only returns FALSE when both K2 and L2 are false.


"Sharon" wrote:

I have a spreadsheet where I need to compare two columns and get a true,
false value.

Column D

Column J


I need to compare column D to column J: I used the following in column K:

=ISNA(MATCH(D2,$J$2:$J$457,FALSE))

to compare J to D in column L: =ISNA(MATCH(J2,$D$2:$D$457,FALSE))

I can see that the first one is incorrect because there is a duplicate value
in D2 and J6.

Then, I want to have a column where the value returns true if column K or L
is true:

=IF(OR(K2=TRUE,L2=TRUE),TRUE)


I tried th

=VLOOKUP(D2,'Sheet 1'!$J$2:$J$457,2,FALSE)

which I got from another post.

Can someone please tell me how to do this? Thanks.


--
S