123 screw
265 bolt
847 washer
But this list can get really long. Each part number and each description is a seperate text string or mtext string.
I plan on having an excel spreadsheet that has a list of all part numbers that my company uses with their corresponding descriptions.
I would like to use the part number to find the appropriate description and then change the description.
Hopefully this can be done automatically for a list of part numbers and their descriptions.
Is there a way to do this?