Maybe this would work, depending on what information is in your parts:
The balloons display whatever is listed in the (excel-based) column named "itemno".
So if you let Excel fill this column with some formula the result of that will also be displayed in the balloon. For example, use
"M"&C2...