I'm getting a !VALUE error here, can someone please help me fix my formula or simplify it. Any help would be greatly appreciated.
=IF(K4&S4<>"342Prestige","Not needed"),IF(Y4="","Input Imp SAP Box",IF(OR(Y4="N6P 420",Y4="L6P 430",AB4="ICBP",K4=805),"Not needed",IF(AND(Y4="ANP 430",S4="Prestige",F4>0),"ok",IF(AND(Y4="A6P 430",S4="Prestige",F4>0),"ok",IF(AND(X4="India",F4>0),"ok",IF(OR(Y4="A6P 430",Y4="ANP 430"),IFERROR(VLOOKUP(B4&X4,GOS!A:D,4,0),"Request"),IF(C4="A553",IFERROR(VLOOKUP(B4&9,'NOS Minus'!A:F,6,0),"Request"),IF(C4=5577,IFERROR(VLOOKUP(B4&5,'NOS Minus'!A:F,6,0),"Request"),IF(OR(Y4="F6P 430",Y4="F5P 420"),IFERROR(VLOOKUP(B4&K4,'NOS Minus'!A:F,6,0),"Request"))))))))))
=IF(K4&S4<>"342Prestige","Not needed"),IF(Y4="","Input Imp SAP Box",IF(OR(Y4="N6P 420",Y4="L6P 430",AB4="ICBP",K4=805),"Not needed",IF(AND(Y4="ANP 430",S4="Prestige",F4>0),"ok",IF(AND(Y4="A6P 430",S4="Prestige",F4>0),"ok",IF(AND(X4="India",F4>0),"ok",IF(OR(Y4="A6P 430",Y4="ANP 430"),IFERROR(VLOOKUP(B4&X4,GOS!A:D,4,0),"Request"),IF(C4="A553",IFERROR(VLOOKUP(B4&9,'NOS Minus'!A:F,6,0),"Request"),IF(C4=5577,IFERROR(VLOOKUP(B4&5,'NOS Minus'!A:F,6,0),"Request"),IF(OR(Y4="F6P 430",Y4="F5P 420"),IFERROR(VLOOKUP(B4&K4,'NOS Minus'!A:F,6,0),"Request"))))))))))