Comparing Lists

[Q]

I have this working but I am using two formulas, and want to combine them
into one.

I use =ISNUMBER(MATCH(D3,A$2:A$83,0)) to return a true or false

Then I use this formula to return the text of the cell that is different
=IF(G2=FALSE,D2,"")

How can I combine the two into one formula?

[Bob Phillips]

How about

=IF(ISNA(MATCH(D3,A$2:A$83,0)),D2,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Q" <[email protected]> wrote in message
news:[email protected]...
> I have this working but I am using two formulas, and want to combine them
> into one.
>
> I use =ISNUMBER(MATCH(D3,A$2:A$83,0)) to return a true or false
>
> Then I use this formula to return the text of the cell that is different
> =IF(G2=FALSE,D2,"")
>
> How can I combine the two into one formula?