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