Hello,

Good Day to everyone.

Can i NEST the IFERROR function? I'm avoiding the circular reference error so instead i use the IFERROR function + Vlookup function

and example of my formula

=IFERROR(VLOOKUP(A27,'OLE-NURSING'!$A$1:$AF$1000,6,FALSE),VLOOKUP(A27,'OLE-NON-NURSING'!$A$1:$AF$1268,6,FALSE))
but i have a third condition now, so how can i incorporate in my formula above the third condition?

Hoping for your immediate help! Thanks!