VLOOKUP DEFAULT ERROR (WOULD LIKE TO CHANGE)

[grev]

I would like to change the default error message when using the VLOOKUP function. The #N/A is too busy on a large spread sheet. I saw somewhere to use this =vlookup(x,table,c,0,0) stated result was a 0 would result. Did not work. Need help

 

[grev]

[No message]

 

[grev]

When I use this formula I would like to sum and have simple math calculations on the columns where the results are returned. It gives me a #VALUE. This first began when I introduced the formula you sent me to the spreadsheet and left the bottom formulas with simple calculations like sum where housed. They gave the #VALUE. I reentered those using the summation button, but for adding two empty cells it still gives me #VALUE. I tried the VALUE and CLEAR function. Any suggestions??? Thanks