Hi Noorin i have tireed my best but stilll not undeerstand the below point could you please explain me what is mean by this
name range of below function is getphoto----------------------Formula-define name-then paste below formula and put name range........ =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) On Wed, Jul 27, 2011 at 9:23 AM, XLS S <xlst...@gmail.com> wrote: > Hey, > > please find the below mention link.... > > > http://www.jkp-ads.com/articles/ShowPicture00.asp > > > > > On Tue, Jul 26, 2011 at 5:32 PM, ICWAI Help <icwai.answ...@gmail.com>wrote: > >> Hi How the 3rd example sheet works or photo example sheet workds please >> explain clearly..:) >> >> >> On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer < >> chhajersand...@gmail.com> wrote: >> >>> Dear Noorain, >>> >>> I have gone through your attachment and find it of a graet help. I hope >>> you wont mind to guide us in a *step by step* *action to be done* for >>> your all four examples. >>> >>> Thanking you in advance. >>> >>> >>> >>> On 25 July 2011 23:14, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: >>> >>>> Dear Neil, >>>> >>>> Please see attached sheet with Indirect function example >>>> >>>> -- >>>> Thanks & regards, >>>> Noorain Ansari >>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>>> >>>> >>>> On Mon, Jul 25, 2011 at 9:04 PM, neil johnson < >>>> neil.jh...@googlemail.com> wrote: >>>> >>>>> Hi All, >>>>> Is indirect function is good function to make dashboard. Please explain >>>>> about indirect function and provide me some example. how can i use >>>>> indirect >>>>> function while to make dashboard. >>>>> >>>>> Thanks >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> >>> >>> -- >>> Regards, >>> Sandeep Kumar Chhajer. >>> Ph. no: 07498171901 >>> >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > ......................... > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel