Vlookup Error

I am trying to embed 2 VLOOKUPs in a function and if the result of both are an Error (#N/A) the value shown is 0.

I tried a handful of combinations, but Excel keeps telling me there are too many arguments embedded. An example I was trying was

=IF(ISERROR(VLOOKUP1),IF(ISERROR(VLOOKUP2),0,VLOOKUP2),VLOOKUP1)

So if Vlookup1 was an error, it then went onto the second IF and checked to see if Vlookup2 was an error. If both were an error, it resulted in 0. If Vlookup2 was good, it showed that result. Looking back at the first IF statement, if the VLOOKUP1 isn't an error, it showed VLOOKUP1.

Excel don't let me do this, and I am sure there's an easier way to do this. I just need the resulting value if both VLOOKUPS error-out to be 0.

Thank you!

VLOOKUPERROR.xlsxYou are probably right, I was in a bit of a hurry at first. here is an example.

In column C I want to enter a formula that will first lookup the value in Column B in the Pricing Data tab, if it results in an error (the pricing isn't listed for the Ship-to/Product combo), it will do the same vlookup but with the value in Column A. If that also results in an error, it should return 0.

To help, in Column E I've put what the right formula should return.

That worked, thank you!