Hi
(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:
aqpPqd12 $25
aqpPqd14 $30
aqpSqd15 <blank cell>
aqpSqd15W10 $70
On sheet2 I have a shortened list of a...