NOORAIN Sir,
Thanks very much Sir
On Fri, Aug 17, 2012 at 12:01 PM, NOORAIN ANSARI
wrote:
> Dear Amar,
>
> Please try it.
>
> *=IF(ISERR(INDEX(INDIRECT($D$2),C4)),"",INDEX(INDIRECT($D$2),C4))*
>
> see attached sheet.
>
>
> On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
>
>> Thanks to all v
Dear Amar,
Please try it.
*=IF(ISERR(INDEX(INDIRECT($D$2),C4)),"",INDEX(INDIRECT($D$2),C4))*
see attached sheet.
On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it right? I
Hi Pravin,
Formula is not work I will try
On Thu, Aug 16, 2012 at 6:50 PM, Pravin Gunjal wrote:
> Dear Amar
>
> You may use the same formula
>
> =IFERROR(INDEX(INDIRECT($D$2),C10),"")
>
> *With regards,
>
> **Pravin Gunjal**
> *
>
>
> On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
>
>>
Dear Amar
You may use the same formula
=IFERROR(INDEX(INDIRECT($D$2),C10),"")
*With regards,
**Pravin Gunjal**
*
On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it ri
Thanks to all very much.One question ask to all there are custom formatting
then error will disappear in cell?Is it right? I used index formula in my
sheet but it show reference.
I attached sheet here Pl see all.
On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh wrote:
>
> You're Great Noorain Sir.
You're Great Noorain Sir.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI wrote:
> Dear Amar,
>
> In
Dear Amar,
In case of 2003 Version
You can also use..
=IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
Or
=IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>
> --
> Join official facebook page of this f
Dear Amar,
Use Iferror before the desire formula.
you can use: =IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"")
Thanks & Regards,
*Deba Ranjan P*
On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/di
--
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 titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n
