Error In Complex Formula

[wsnyder]

Hi all,

Using Microsoft365.
My Formula returns "There is a problem with this formula..."
But I do not see what the problem is. Do you see the problem?

Thanks
-w

IF(M4="MASTER",
     if(OR(VLOOKUP($P4,'End Dates'!$A$2:$D$1434,4,FALSE)=1,
                  ISERROR(VLOOKUP($P4,'End Dates'!$A$2:$D$1434,4,FALSE))
                ),
                  If(iserror(VLOOKUP($P4,'Ace_End_Dates'!$A$2:$c$66173,3,FALSE)),
                       1,
                       VLOOKUP($P4,'Ace_End_Dates'!$A$2:$c$66173,3,FALSE)
                      ),
              VLOOKUP($P4,'End Dates'!$A$2:$D$1434,4,FALSE)
         ),
          
       if(or(VLOOKUP($P4,'End Dates'!$A$2:$D$1434,3,FALSE)=1,
                  iserror(($P4,'End Dates'!$A$2:$D$1434,3,FALSE))
                 ),
                  If(iserror(VLOOKUP($P4,'Ace_End_Dates'!$A$2:$c$66173,3,FALSE)),
                       1,
                       VLOOKUP($P4,'Ace_End_Dates'!$A$2:$c$66173,3,FALSE)
                      ),
              VLOOKUP($P4,'End Dates'!$A$2:$D$1434,3,FALSE)
         )
)

 

[shknbk2]

Are you missing "VLOOKUP" in this line? Between the two back to back left parens?

iserror(($P4,'End Dates'!$A$2:$D$1434,3,FALSE))

 

[wsnyder]

Thanks shknbk2,

That resolved it, works perfectly!

thanks,
-w