IF and VLOOKUP Calculations so it does not return N/A

hello,

I am trying to figure a formula that will perform the calculation if it is greater than 0, otherwise I want it to return 0 or leave it blank.

for example

Cell A13 has the initial of CH.

In another tab, I have the initial on the left side and dollar value on the right. So i.e CH $10.00

So in A14, i want it to have $10.00 as it corresponds with the initial. However, if the other tab has no amount, it returns a "N/A". I want it to say 0 or blank instead of N/A.

Currently my formula in A14 is VLOOKUP(A13,WorkOrderList,2) which works fine when there is a value in column 2 in the other tab, but returns N/A if blank.

I am trying to see if I can do a formula where if the vlookup value returns a number greater than 0 then calculate the vlookup, otherwise blank. not sure if this is possible or the best way.

Any ideas would be appreciated!

it is still returning N/A

You could use iferror, this formula is from one of my spreadsheets, =IFERROR(VLOOKUP(Q64,'Department standard hour list'!$A$2:$D$390,4,FALSE)*P64,0) this formula returns a value of 0 instead of N/A.
IFERROR in other words if N/A return 0 (see the last part of the formula)
Hope that helps

Just saw your reply if with the Iferror and that one works. thank you so much!