Matching Parent Item with Component Item

[beronson]

I am identifying component items which will be Made-to-Stock (MTS) for parent items which are Assemble-to-Order (ATO) for manufacturing purposes.

What I would like to do is:

• In column A, list all of my items which are ATO
• In column B, compare the first 6 characters of column A to a list of part numbers on a different sheet, but only return a value if the first 6 characters match and the part number ends in WY
• The returned value should be the full part number of the matching item

What formula(s) and column structuring will support this?

Thanks,
Bronson

 

[shg]

You're welcome.