you need a lookup table EXAMPLE

1c 20
2c 30
3c 40

=vlookup(2c,table,2)+vlookup(3c,table,2)

returns 70

if you want to code the 70 u need another lookup table2

60 6c
70 7c
80 8c

=vlookup(vlookup(2c,table,2)+vlookup(3c,table,2),t able2,2)

returns 7c


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=527510