=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?