Two Vlookups in one formula. How to add IFERROR show blank?

[Eduards]

Hi

I have this formula here:

Please Login or Register  to view this content.

If my cells come up as '#N/A' how do I amend the function to remove that?

I tried the following:

=IFERROR(VLOOKUP($A2,Inner!$A:$E,4,FALSE),VLOOKUP($A2,Outer!$A:$E,4,FALSE),"")

[FDibbins]

Try adding another IFERROR...
=iferror(IFERROR(VLOOKUP($A2,Inner!$A:$E,4,FALSE),VLOOKUP($A2,Outer!$A:$E,4,FALSE),""))

[Eduards]

Too many arguments it says

[FDibbins]

oops had the 2nd last ) wrong...
=IFERROR(IFERROR(VLOOKUP($A2,Inner!$A$1:$E$65536,4,FALSE),VLOOKUP($A2,Outer!$A$1:$E$65536,4,FALSE)),"")

[FDibbins]

Happy to help, thanks for the feedback