NOORAIN Sir,
Thanks very much Sir
On Fri, Aug 17, 2012 at 12:01 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
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
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 amartak...@gmail.com wrote:
Thanks to all very much.One question ask to all there are custom
formatting then error will disappear in
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 amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
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 amartak...@gmail.com wrote:
--
Join official facebook
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
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 naukrikuld...@gmail.comwrote:
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 amartak...@gmail.com wrote:
Thanks to all very much.One question ask to all there are custom
formatting then error will disappear
Hi Pravin,
Formula is not work I will try
On Thu, Aug 16, 2012 at 6:50 PM, Pravin Gunjal isk1...@gmail.com 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