=IF(ISERROR(VLOOKUP(xx,XX:XX,X)),0,VLOOKUP(xx,XX:X X,X))
--
Kevin Backmann


"hitesh" wrote:

my database is in sheet1,and in sheet2 i used the vlookup formula
but after using the formula.in some place its show #N/A.insteaf of #N/A
i want 0. so please help me on this. vlookup formula is important for me,so
i cant delete that formula