wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
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
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
Excel Formula:
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)
)
)