vlookup function

[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

 

[Bob Phillips]

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

or if you have Excel 2007

=IFERROR(vlookup_formula,0)

 

[jez]

thanks bob, worked very well
cheers

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

or if you have Excel 2007

=IFERROR(vlookup_formula,0)

--
__________________________________
HTH

Bob