ExcelBanter - vlookup function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - vlookup function (https://www.excelbanter.com/excel-programming/420495-vlookup-function.html)

Jez

vlookup function

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[_3_]

vlookup function

=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

Jez

vlookup function

thanks bob, worked very well
cheers

"Bob Phillips" wrote:

=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

All times are GMT +1. The time now is 09:35 AM.