Hi,
I need some help on I believe a nested IF formula.
In the attached workboook the formula would start in cell D6 and go down to cell D13.
In an ideal world, column L would be completely filled in with customer names and I would just to do =L6 and drag down.
However, if an order number from column C starts with a 7, then the customer name does not appear in column L.
There is two rules for an order number starting with a 7.
Rule 1 is if the grade is COFFEEESS 138 then the customer is DPK.
Rule 2 is if the grade is not COFFEEESS 138 then the customer is LGT.
So I think I need 3 separate calculations but in the same same formula. The formula would firstly check if there is a customer name in column L, if it is then it takes that customer name. If there is no customer name then I would need to apply the 2 rules above.
Any help on this would be greatly appreciated.
Aarron
Bookmarks