glegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* 15 April 2013 6:18
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Remove NA Error
>
> ** **
>
> Dear Chaya
>
> Thats perfect formula but I used
ma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 15 April 2013 6:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Remove NA Error
Dear Chaya
Thats perfect formula but I used Excel 2003.So It is not useful for me.Pls
Dear Chaya
Thats perfect formula but I used Excel 2003.So It is not useful for me.Pls
suggest for Excel 2003 Supported formula.
Thank again for help me
Regards
Amar
On Mon, Apr 15, 2013 at 6:07 PM, Chaya wrote:
> Dear Amar,
>
>PFA...
>
>
> On Mon, Apr 15, 2013 at 6:03 PM, amar takale wrote
Dear Chaya
Thanks for Reply & suggest formula for Remove NA but it show NAME Error.
Pls see it
Thanks
Amar
On Mon, Apr 15, 2013 at 5:53 PM, Chaya wrote:
> Dear Amar,
>
> Use , As example
> =IFERROR(INDEX(INDIRECT($C$3&"!L:L"),MATCH($C7,INDIRECT($C$3&"!K:K"),0)),"")
>
> Regards,
> Chaya
>
>
>
Dear Amar,
Use , As example
=IFERROR(INDEX(INDIRECT($C$3&"!L:L"),MATCH($C7,INDIRECT($C$3&"!K:K"),0)),"")
Regards,
Chaya
On Mon, Apr 15, 2013 at 5:44 PM, amar takale wrote:
> Dear All
> Can anybody tell me how to remove NA from Attached Sheet in Output
> worksheet.I try with IF ISERROR but n
