excell help

[Ken]

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]

your problem is not clear. post a sample data

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