I have a list of parts numbers (alphabetical and numeric) and want to use
these in a sum.
How can I include these in a sum eg if C1= EV1, C2=EV2?
Alternatively if not possible can I use the SUBSTITUTE function to pick this
text from a list
Thanks in advance