Please help, I am looking to create an inventory worksheet that I need a
vlookup formula for a value across multiple worksheets and sum the difference
of the returned values for that specific argument.

EX)
Lookup piece 12345 and the piece 12345 appears in multiple cells in two
other worksheets. How do I sum the difference of all the value additions
minus subtractions and return in a specific column with a formula.

Any help you can give is greatly appreciated.

Regards,
Christine