ExcelBanter - Comparing Lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Comparing Lists (https://www.excelbanter.com/excel-worksheet-functions/54191-comparing-lists.html)

Comparing Lists

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

Comparing Lists

How about

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

--

HTH

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

"Q" wrote in message
...
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?

All times are GMT +1. The time now is 07:05 PM.