IFERROR with IF statement as "value if error"

[smstrickland]

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?

 

[Fluff]

Try

=Iferror(VLOOKUP([@Project],PPNs!A:D,4,FALSE),IF(E4=" Labor","Labor",VLOOKUP([@[Dept Code]],'Dept Owners'!A:B,2,FALSE)))

 

[smstrickland]

=Iferror(VLOOKUP([@Project],PPNs!A:D,4,FALSE),IF(E4=" Labor","Labor",VLOOKUP([@[Dept Code]],'Dept Owners'!A:B,2,FALSE)))

That worked great! Thank you

 

[Fluff]

You're welcome & thanks for the feedback.