formula

[Julie]

I need to make a formula that if any item in column E is equal to any of the
items in column A then the quantity in column F(beside the item in E) needs
multiplied by the set price in column B(beside the item in A) example:

our set price list forecast sent to us
A B E F
15354792 .056 15418001 2000
15418001 .032 12129811 5000
12034476 .011

 

[M Kan]

Use a VLOOKUP + ISERROR combo to match one list to the other and perform the
math based on the looked up value. If there is no match, the VLOOKUP will
return an #NA error, which the ISERROR can change to whatever else you need:

http://www.kan.org/tips/excel_comparing_lists.php

 

[John C]

I am still do not see where the overpayment is taken into account (the
balance of -100), or the 'discount' given of 72.

Is there a way you could post the file (there are many free file hosters out
there, I just don't have a name of one). A sample file anyway...

Thanks.