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!
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!