Re: $$Excel-Macros$$ Re: Cell show blank but in it show formula

2012-08-21 Thread amar takale
Thanks very much Vijayajith. On Fri, Aug 17, 2012 at 8:49 PM, vijayajith VA wrote: > HI Prince,,, > > To avoid 0 s & na please use below formula > > =IF(VLOOKUP(F4,B4:D9,2,0)=0,"",VLOOKUP(F4,B4:D9,2,0)) > > > On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey wrote: > >> Please see the attachment >>

Re: $$Excel-Macros$$ Re: Cell show blank but in it show formula

2012-08-17 Thread vijayajith VA
HI Prince,,, To avoid 0 s & na please use below formula =IF(VLOOKUP(F4,B4:D9,2,0)=0,"",VLOOKUP(F4,B4:D9,2,0)) On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey wrote: > Please see the attachment > > > regards > prince > > On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote: >> >> >

RE: $$Excel-Macros$$ Re: Cell show blank but in it show formula

2012-08-16 Thread Rajan_Verma
cel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Cell show blank but in it show formula Please see the attachment regards prince On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote: -- Join official facebook page of this forum @ https://www.facebook.com/di

$$Excel-Macros$$ Re: Cell show blank but in it show formula

2012-08-16 Thread Prince Dubey
Please see the attachment regards prince On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote: > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread