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!