IFNA nested into an if statement w/ a vlookup also nested

[hmsmith54]

I have an if statement to tell me if there is a specific value "CAD" and if it equals CAD to do a vlookup to pull in a dollar amount based on a value in another cell. This I have working fine, however, I need to go one step further and if the error #N/A comes up I need it to pull in a 0.

This is my beginning formula

=IF(G2="CAD",VLOOKUP(C2,INVOICE,5,FALSE), "Not CAD ")

I do not know where (or if it is even possible) to add an if iserror or and IFNA statement to pull in 0.

Any help would be greatly appreciated!

 

[Rasscal]

Perfect, thank you so much for your help.

 

[AlanY]

you're welcome