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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
"Julie" wrote:
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