Forum Discussion
IF AND
=AM3*(IFS(AND(AJ3="BASELINE";AB3="mini");Inf_Sales_Dashboard!$I$219);(AND(AJ3="BASELINE";AB3="micro");Inf_Sales_Dashboard!$I$220);(AND(AJ3="BASELINE";AB3="mid-tier");Inf_Sales_Dashboard!$I$221);(AND(...
There's a few ways to do this. Any time the logic gets beyond 3-4 If-then scenarios, I prefer to use a lookup formula. I'm aware of IFS and know how to use it but prefer a simpler approach.
Create a dedicated lookup table and use VLOOKUP or XLOOKUP and you'll have a short formula like this:
=XLOOKUP(F3:F6&G3:G6,A2:A13&B2:B13,C2:C13)