matching data in columns
 

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.
--
K.Cunningham

matching data in columns
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"k cunningham" wrote:

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.
--
K.Cunningham

matching data in columns
 

I"m getting an error on "Match", should that be a single quote?
--
K.Cunningham


"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"k cunningham" wrote:

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.
--
K.Cunningham

matching data in columns
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"k cunningham" wrote:

I"m getting an error on "Match", should that be a single quote?
--
K.Cunningham


"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"k cunningham" wrote:

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.
--
K.Cunningham