smstrickland
New Member
- Joined
- Jul 13, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Can us use the an IF statement as the "value if error" when using IFERROR? Here's what I am trying to write: =Iferror(VLOOKUP([@Project],PPNs!A:D,4,FALSE),IF(E4=" Labor","Labor"),(VLOOKUP([@[Dept Code]],'Dept Owners'!A:B,2,FALSE))) but excel does not like it. If this is not possible, is there another way to approach this problem?