|Does your VLOOKUP even work?|
I don't believe that you can use a 0 as the col_index_num. Since there is no Column 0 in a range, doesn't the function return a #VALUE error?
In any case, the standard way to avoid seeing the #N/A error is to wrap an IF function around your VLOOKUP.
Note that I changed your formula so that it uses a valid col_index_num argument of 3.
or, since 0 and 1 can be used as the range_lookup argument...
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.