Forum Discussion
WishIWerentAN00b
Sep 02, 2022Copper Contributor
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(...
OliverScheurich
Sep 02, 2022Gold Contributor
=VLOOKUP(AJ3&AB3,CHOOSE({1,2},$A$3:$A$14&$B$3:$B$14,$C$3:$C$14),2,0)*AM3
You can try this formula with a reference table which is in range A3:C14 in this example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=Inf_Sales_Dashboard!I219
This formula is entered in cell C3 and copied down to cell C14.