I have a list of products with a corresponding trade value. e.g:

Product Code Trade Value (£)
01 100
02 245
03 453
04 546
05 6756
06 980
07 2435
08 346356
09 4235
10 45
11 476
12 356
13 3566
14 588

Now i also have a list of product Exceptions-these are 6-digits long,
but the first 2-digits correspond to the above numbers. e.g:

Product Val(£)
012657 10
013458 5
014456 6
024565 3
025455 12
034345 20

and so on.

I want to create a new list that subtracts the 6-digit values from the
2 digit values. So for product 01 the calculation would be
100-10-5-6=79. The new table would look like:

Product Val
01 79
02 230
03 433

etc

Is there a formula to do this, thanks for the help.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=508126