Trying to wrap a nested if(vlookup) statement in an IFerror

Hi everyone,

Here's my formula:

=IF(VLOOKUP(A8,'CORE Data 3 Month #1'!A:K,6,FALSE)<(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)-(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)*0.03)),'CORE Data 3 Month #2'!$A$1,IF(VLOOKUP(A8,'CORE Data 3 Month #1'!A:K,6,FALSE)>(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)+(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)*0.03)),'CORE Data 3 Month #2'!$C$1,'CORE Data 3 Month #2'!$B$1))

What I'm trying to do is wrap this entire formula into an IFERROR or something similar so that if the total result is an error like #N/A, then the cell should result in "Not Available". I've tried:

=IF(iferror(VLOOKUP(A8,'CORE Data 3 Month #1'!A:K,6,FALSE)<(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)-(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)*0.03)),'CORE Data 3 Month #2'!$A$1,IF(VLOOKUP(A8,'CORE Data 3 Month #1'!A:K,6,FALSE)>(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)+(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)*0.03)),'CORE Data 3 Month #2'!$C$1,'CORE Data 3 Month #2'!$B$1)),"Not Available")

But there's some error in it that's prevent the formula from being accepted.

Any ideas?

Thanks!

you need to put around the IF statement
so

=IFERROR(IF(VLOOKUP(A8,'CORE Data 3 Month #1'!A:K,6,FALSE)<(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)-(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)*0.03)),'CORE Data 3 Month #2'!$A$1,IF(VLOOKUP(A8,'CORE Data 3 Month #1'!A:K,6,FALSE)>(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)+(VLOOKUP(A8,'CORE Data 3 Month #2'!A:K,6,FALSE)*0.03)),'CORE Data 3 Month #2'!$C$1,'CORE Data 3 Month #2'!$B$1)),"Not Available")