Formula Modification
 

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.

Formula Modification
 

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

<JoJo wrote in message ...
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.

Formula Modification
 

try this

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


"JoJo" wrote:

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.