Match & add missed items between two sheets

Report
Posts
13
Registration date
Wednesday March 3, 2021
Status
Member
Last seen
January 13, 2022
-
Posts
13
Registration date
Wednesday March 3, 2021
Status
Member
Last seen
January 13, 2022
-
Hello,


I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 .
it should match column B in sheet1 with sheet2. as in the orginal data in sheet2 IN COLUMN B:C there are some missed items , should add them in column B and show the missed items in column C as I put the expected result H:I and should replace data when add new data into sheet2 after match with sheet1
here is my file https://www.dropbox.com/scl/fi/gqocq4ms49f9vlpugslhz/Bridgestone-Report.xlsm?dl=0&rlkey=jhrfql8y5gq5euskx4dlv0sh2
I hope some body help

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Abdo,

Not sure if this is possible.

Finding this string "13 R22.5 R187 " in this one "BS 13 R22.5 R187 JAP" and show what is missing can be done. But finding this one "BS 1200 R20 M802 " in this one "BS 1200 R20 18PR M802 THI" is too much.
We could skip the last part and search for "BS 1200 R20", but then we would also find "BS 1200 R20 18PR G580 THI" and "BS 1200 R20 G580 JAP". With that last one "BS 1200 R20 G580 JAP", we would need to skip the last 2 parts to find its match.

I don't see how this can be done.

Best regrads,
Trowa
Posts
13
Registration date
Wednesday March 3, 2021
Status
Member
Last seen
January 13, 2022

HI Trowa,
I knew it . this is the big challenge. so I accept any alternative you suggest.
just tell me what's the right way you see it .
thanks