#N/A error
 

I'm using the VLOOKUP formula. Because some numbers are not found, the cell
shows error #N/A. Using a formula, is there any way the cell can return 0
instead #N/A?

#N/A error
 

=IF(ISERROR(VLOOKUP([your vlookup])),0,VLOOKUP([your vlookup]))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Almir Vargas" wrote:

I'm using the VLOOKUP formula. Because some numbers are not found, the cell
shows error #N/A. Using a formula, is there any way the cell can return 0
instead #N/A?

#N/A error
 

Something like
=IF(ISNA(VLOOKUP(E3,A1:B100,2,FALSE)),0,VLOOKUP(E3 ,A1:B100,2,FALSE))
Regards,
Alan.
"Almir Vargas" wrote in message
...
I'm using the VLOOKUP formula. Because some numbers are not found, the
cell
shows error #N/A. Using a formula, is there any way the cell can return 0
instead #N/A?

#N/A error
 

thanks for making my day easier. have a nice weekend!

"Alan" wrote:

Something like
=IF(ISNA(VLOOKUP(E3,A1:B100,2,FALSE)),0,VLOOKUP(E3 ,A1:B100,2,FALSE))
Regards,
Alan.
"Almir Vargas" wrote in message
...
I'm using the VLOOKUP formula. Because some numbers are not found, the
cell
shows error #N/A. Using a formula, is there any way the cell can return 0
instead #N/A?

#N/A error
 

=IF(ISNA(VLOOKUP(H1,B1:F28,2,FALSE)),0,VLOOKUP(H1, B1:F28,2,FALSE))


Gord Dibben MS Excel MVP


On Fri, 2 Mar 2007 06:31:28 -0800, Almir Vargas
wrote:

I'm using the VLOOKUP formula. Because some numbers are not found, the cell
shows error #N/A. Using a formula, is there any way the cell can return 0
instead #N/A?