(I really hope Im explaining this sensibly...)
On sheet1 I have a list of part numbers, approx 20,000 rows long. Some of the Part numbers have a "W10" added to the end:
aqpSqd15 <blank cell>
On sheet2 I have a shortened list of a...