I've attached a workbook which has me stumped on a formula which uses an "IF" statement followed by 5 VLOOKUP formulas.
The actual workbook I'm using has thousands of rows and thousands of "orders" where i need to obtain the profit/loss for each order number.
You'll see the problematic formula in cell U11, along with a written explanation of what it is supposed to do.
I wonder if I've incorrectly nested the formulas... or if the prob is elsewhere... or if there's a better solution than all these VLOOKPs!
Please let me know if you have any questions.
I appreciate your help. And stay safe!
Bookmarks