First of all.................your lookup value cannot be a range of cells so
you must re-write the original formula.

=VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)

Now to get rid of the #N/A

=IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))

Copy down as far as you need.


Gord Dibben MS Excel MVP

On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799
wrote:

I am not good at this at all, novice at best. This is my current formula,
are you able to tell me how to alter my formula to yield a - or 0? I
appreciate your help

=VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE)