RE: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread Rajan_Verma
See if it helps From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Monday, August 08, 2011 11:37 AM To: Google Subject: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks... Dear All, Find attached query regarding While

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread Venkat CV
Dear Ashish, WorkingThank you Dear Noorain, Ashish's formula WorkingThanks for your try. *Best Regards,* *Venkat * *Chennai* * * On Mon, Aug 8, 2011 at 12:33 PM, ashish koul wrote: > IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)="","",VLOOKUP(I3,$B

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread NOORAIN ANSARI
Dear Venkat try it =IF(OR(VLOOKUP(F3,$B$3:$C$14,2,0)=0,VLOOKUP(F3,$B$3:$C$14,2,0)=""),"",VLOOKUP(F3,$B$3:$C$14,2,0)) On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV wrote: > Dear Noorain, > > Thanks for your Try... > The Below Formula is working for Cell is Blank... > > But If cell Value is 0 That's

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread ashish koul
IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)="","",VLOOKUP(I3,$B$3:$C$14,2,0)),"Not Found") On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV wrote: > Dear Noorain, > > Thanks for your Try... > The Below Formula is working for Cell is Blank... > > But If cell Value is 0 Tha

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-07 Thread Venkat CV
Dear Noorain, Thanks for your Try... The Below Formula is working for Cell is Blank... But If cell Value is 0 That's the case not working... If Cell is 0 and also Coming Blank...It should Come has a 0 *Best Regards,* *Venkat * *Chennai* On Mon, Aug 8, 2011 at 11:43 AM, NOORAIN ANSARI wrote: >

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-07 Thread NOORAIN ANSARI
Dear Venkat, Please try. =IF(VLOOKUP(I11,$B$3:$C$14,2,0)=0,"",VLOOKUP(I11,$B$3:$C$14,2,0)) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Mon, Aug 8, 2011 at 11:37 AM, Venkat CV wrote: > Dear All, > > Find at

$$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-07 Thread Venkat CV
Dear All, Find attached query regarding While Using Vlookup Insted of Zero need Blanks *Best Regards,* *Venkat * *Chennai* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri