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

or if you have Excel 2007

=IFERROR(vlookup_formula,0)

--
__________________________________
HTH

Bob

"jez" wrote in message
...
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