matching data in columns

K

k cunningham

I have 3 columns: column A has client number, column B has Client name.
Column C has Client Name and Number. Column A and B can be merged, then
would need to match to Column C. Appreciate any help.
 
D

Dave F

1) Create a helper column in column D and enter =CONCATENATE(A1,B1) and fill
down as necessary.
2) Create a second helper column in column E and enter
=IF(ISNUMBER(MATCH(D1,$C$1:$C$100,0),"Match","No match") and fill down as
necessary.

Dave
 
D

Dave F

Not, the quotes around Match should be double quotes. One thing to check is
to make sure that that the data in Columns C and Column D are formatted the
same.

Dave
 
Top