Try it like this:

=IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....))

--
Biff
Microsoft Excel MVP


"Cathy" wrote in message
...
using vlookup i want anytime a #/na is returned to be replaced with 0. I
haven't had any luck with nesting commands to get this acomplished.
thanks