Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
thanks kevin
thanks kevin u r formula helps me thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|