Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
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. -- John C "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|