Need Help Modifying IF(OR) Formula

[PattiK323]

CURRENT FORMULA: IFERROR(IF(OR($L9="PSI",$L9="PTC",$L9="PQS",$L9="PST"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," ")

Prioritizes production across all machines the same: PSI, PTC, PQS, PST.

Want to modify formula, to look at cell $D9 first, and based on the machine, prioritize production accordingly, as noted below. How do I write the formula to accomplish this?

IF $D9=”135301”:
IFERROR(IF(OR($L9="PTC",$L9="PST"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," ")

[only want to prioritize PTC and PST]


IF $D9=”135302”:
IFERROR(IF(OR($L9="PST"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," ")

[only want to prioritize PST]


IF $D9=”135303”:
IFERROR(IF(OR($L9="PTC",$L9="PQS"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," ")

[only want to prioritize PTC and PQS]


IF $D9=”135304”:
IFERROR(IF(OR($L9="PSI",$L9="PQS"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," ")

[only want to prioritize PSI and PQS]

THANK YOU!

 

[CSmith]

This?

Book1
	A
9	No Condition Met
aliaslamy2k

Cell Formulas
Range	Formula
A9	A9	=IF($D9="135301",IFERROR(IF(OR($L9="PTC",$L9="PST"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," "),IF($D9="135302",IFERROR(IF(OR($L9="PST"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," "),IF($D9="135303",IFERROR(IF(OR($L9="PTC",$L9="PQS"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," "),IF($D9="135304",IFERROR(IF(OR($L9="PSI",$L9="PQS"),S9,(VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9))," "),"No Condition Met"))))

 

[jasonb75]

I think that this should do what you need

=IFERROR(IF(OR(SEARCH($D9,"PSIPTCPQSPST")=INDEX({10,10,7,7;4,10,4,1},0,--RIGHT($L9))),S9,VLOOKUP(CONCATENATE($C9," Balance % By Month"),$AC$1:$AP$4,5,FALSE)*$AC9),"")