PDA

View Full Version : Column compare



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!

mikerickson
05-30-2011, 03:34 PM
If the entries in column C are sorted ascending, try
=IF(ISERROR(MATCH(LOOKUP(A1, $C$1:$C$597)&"*", A2, 0)), "", "x")