Use

=IF(ISNA(Vlookup(),0,Vlookup()))

replace Vlookup() with your VLOOKUP formula...


"Cathy" wrote:

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