lienlee
05-30-2011, 12:32 PM
Hi Guys,
The following statement here is what I use to compare column A and C.
I insert this statement into column B and it would print out the string if there is a match between A and C.
However, for example..
Column A has Anderson, Michael Scott
and column B has
Anderson, Michael
It does not recognize the match. Is there a way to by pass this? with making the statement/code too complexed.
=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),"",A2)
Thank you!
The following statement here is what I use to compare column A and C.
I insert this statement into column B and it would print out the string if there is a match between A and C.
However, for example..
Column A has Anderson, Michael Scott
and column B has
Anderson, Michael
It does not recognize the match. Is there a way to by pass this? with making the statement/code too complexed.
=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),"",A2)
Thank you!