#N/a
 

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

#N/a
 

=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

#N/a
 

Hi,

Kevin is right, but try to take a look if the both ranges are in the same
ascending or descending order

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"hitesh" escreveu:

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

#N/a
 

Thanks for the cool reminder Marcelo, I hadn't thought of that producing an
error. Not enough coffee perhaps on this hot Texas Monday.
--
Kevin Backmann


"Marcelo" wrote:

Hi,

Kevin is right, but try to take a look if the both ranges are in the same
ascending or descending order

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"hitesh" escreveu:

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

thanks kevin
 

thanks kevin u r formula helps me
thanks again