your problem is not clear. post a sample data

Ken Wrote:
use three colmun
lookup a number in a column if found report cost in another column
and
subtractli the number left in third colmun


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555999