Formula Modification

[Guest]

Folks:


(IF(ISERROR(MATCH(B1,A:A,0)),"No Match","Match")


Column A Column B Column C
25 50 No
Match
30 30 Match
26 28 No
Match
55
60

I am using the above formula to compare two columns (A and B) for
overlapping (common) data then put the result ("Match" OR "No Match") in a
third column.
So far this formula has worked well. But now I would like to modify this
formula so that rather than "Match" or "No Match" the overlapping result
("30" in this case),
gets put into Column C.



Thanks,
Jo.

 

[T. Valko]

Do you still want "no match" ?

=IF(ISNA(MATCH(B1,A:A,0)),"No Match",B1)

Or, this will leave "no match" cells blank:

=IF(ISNA(MATCH(B1,A:A,0)),"",B1)

Biff

 

[Guest]

try this

=IF(A1-B1=0,A1,"")