Comparing Lists

Q

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?
 
B

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)
 
Top