Extracting data
 

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

OK, this will depend on what is the same.. Preuming you ionly need match the
value after the first - in column a with the value before the - in column C:

=if(left(C2,6)=mid(A2,4,6),D2,"")

Course, this depends on how the rest of the data looks.

"SMD" wrote:

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

In cell B2
=IF(COUNTIF(A2,"*"&LEFT(TRIM(C2),6)&"*"),D2,"")

If this post helps click Yes
---------------
Jacob Skaria


"SMD" wrote:

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

Thanks for such a quick reply. Pulling the one piece of information over is
great, but if you will notice the next two in line under Tooling No has the
same number, so therefore I would need for my final result to be 350574,
350575, 643225.


"Jacob Skaria" wrote:

In cell B2
=IF(COUNTIF(A2,"*"&LEFT(TRIM(C2),6)&"*"),D2,"")

If this post helps click Yes
---------------
Jacob Skaria


"SMD" wrote:

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

Thanks for such a quick reply. Pulling the one piece of information over is
great, but if you will notice the next two in line under Tooling No has the
same number, so therefore I would need for my final result to be 350574,
350575, 643225.

"Sean Timmons" wrote:

OK, this will depend on what is the same.. Preuming you ionly need match the
value after the first - in column a with the value before the - in column C:

=if(left(C2,6)=mid(A2,4,6),D2,"")

Course, this depends on how the rest of the data looks.

"SMD" wrote:

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

Well, the 2nd value would pull over as long as your drag the formula down.
Are you saying 109002 and 109008 are similar enough? We would need to know
what is close enough....

"SMD" wrote:

Thanks for such a quick reply. Pulling the one piece of information over is
great, but if you will notice the next two in line under Tooling No has the
same number, so therefore I would need for my final result to be 350574,
350575, 643225.

"Sean Timmons" wrote:

OK, this will depend on what is the same.. Preuming you ionly need match the
value after the first - in column a with the value before the - in column C:

=if(left(C2,6)=mid(A2,4,6),D2,"")

Course, this depends on how the rest of the data looks.

"SMD" wrote:

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

If I understand correctly you need to compare Chart No. AND Tool No.

Try this:

A B C
D E
1 Chart Number Product Part No Tooling No New Column Product Part No
2 91-109002 -000-A 109002 -000 350574
3 91-109002 -000-B 109002 -000 350575
4 91-109008 -000-A 109002 -000 643225
5 91-109023 -000-A 109023 -000 794000

On cell D2: =CONCATENATE($A1," - ",$C1) - copy formula to the last record
On cell E2; =IF(COUNTIF($D$2:$D$<lastrecord,$D2)1,$C1,"") - copy formula
to the last record


SMD wrote:
Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!

Extracting data
 

Kind of hard to explain: See my final answer column. I pulled in all the
records of where the chart number was so similar to the tooling number and it
combined them into one record. After all is said and done, I will be
deleting the tooling no. and data after that.
Chart Number Final Answer Tooling No Product Part No
91-109002 -000-A 350574,350575,643225 109002 -000 350574
91-109002 -000-B 350574,350575,643225 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 794000 109023 -000 794000
91-109023 -000-B 794000 109047 -000 350057
91-109023 -000-C 794000 109047 -000 350059
91-109023 -000-D 794000 109047 -000 350207


"SMD" wrote:

Chart Number Product Part No Tooling No Product Part No
91-109002 -000-A 350574, 109002 -000 350574
91-109002 -000-B 109002 -000 350575
91-109008 -000-A 109002 -000 643225
91-109023 -000-A 109023 -000 794000
I am trying to bring some data together. I need to compare Chart Number and
Tooling Number, if they somewhat match, then I need to bring the 2nd Product
Part No over to the blank Product Part No column. As you may can see I will
have more than one Product Part No (2nd one) and will need to combine them in
the blank Product Part No (1st one) HELP HELP!