vlookup function

J

jez

hello all
when i use vlookup function if one cell has got no data then it displays #N/A
is there a way that can be formatted to display 0 rather then #N/A?
your help would be much appreciate it
many thanks
jez
 
B

Bob Phillips

=IF(ISNA(vlookup_formula),0,vlookup_formula)

or if you have Excel 2007

=IFERROR(vlookup_formula,0)
 
J

jez

thanks bob, worked very well
cheers

Bob Phillips said:
=IF(ISNA(vlookup_formula),0,vlookup_formula)

or if you have Excel 2007

=IFERROR(vlookup_formula,0)

--
__________________________________
HTH

Bob
Click to expand...
 
Top