You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"roxiemayfield" wrote in message
...
Thank you so much. Works great!

"T. Valko" wrote:

One way:

=IF(ISNA(VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13, pmp3w1,3,0))

--
Biff
Microsoft Excel MVP


"roxiemayfield" wrote in
message
...
Hi,

I have the following formula that I am having trouble with. If the
lookup
is
blank I would like the value to be 0. It keeps coming back #NA. What
do I
do
now?

Thank you for your help.

=VLOOKUP($B13,pmp3w1,3,FALSE)