Thread: Comparing Lists
View Single Post
  #1   Report Post  
Q
 
Posts: n/a
Default 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?