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
>>
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:
>>
>>
>
If using Excel 2007 and later can use this :
=IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 16 August 2012 10:53
To: excel-macros@googleg
