On 10/16/11, Sam Mathai Chacko <samde...@gmail.com> wrote:
> Since Noorain and Ashish aren't around, I'll step in. The main function used
> is the INDIRECT function, along with a combo Match function to return the
> position of the value being searched for.
>
> So for example, =INDIRECT("SourcePic!A"&MATCH($A$4,SourcePic!A:A,0)) will
> become =INDIRECT("SourcePic!A2") or =INDIRECT("SourcePic!A3") or
> =INDIRECT("SourcePic!A4") or any relevant number that corresponds to the
> value selected in range A4 of the active sheet. Remember, SourcePic is a
> sheet that contains the pictures.
>
> This INDIRECT equation is given a range name, let us say Photo.
>
> We then insert a picture as a link. How do you do this? You copy a range,
> and paste special as picture link. U can use the camera tool also to do
> this.
>
> Once this is done, the inserted picture is selected, and you can now assign
> a formula to the picture in the formula bar. So you give your range name
> that was defined earlier, =Photo.
>
> As soon as you do this, your equation equates the cell to the relevant
> picture based on the value you have selected in A4 of the active sheet.
>
> The indirect function can be a very versatile one, when used wisely. The
> drawback of the INDIRECT function (which is also is advantage) is that the
> static value that is passed doesn't get updated if the reference gets
> changed. For example, the name of the sheet doesn't get updated when a user
> changes the sheet name. This can be a bit of a problem at times.
>
> In your case specifically, you can get rid of this nuisance by using the
> INDEX function.
>
> So you can use =INDEX(Player,MATCH($A$4,Player,0)) in place of the INDIRECT
> formula above. Player is a named range housing the relevant text entries, as
> well as the pictures thereof.
>
> Check the attachment for more clarity. The function that does all the work
> now is the MATCH function. Hope I have explained it enough. I have also put
> in a work around for the drawback of INDIRECT. HTH.
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
>
>
> On Sun, Oct 16, 2011 at 10:33 AM, prabhat.shrivasta...@gmail.com <
> prabhat.shrivasta...@gmail.com> wrote:
>
>> Hi, can u pls explain the formula being used in this sheet.
>>
>> On Oct 14, 9:45 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote:
>> > Dear prabhat,
>> >
>> > Please find attached sheet in Excel 2003 Version.
>> > Hope it help to u
>> >
>> > --
>> > Thanks & regards,
>> > Noorain Ansari
>> > *http://excelmacroworld.blogspot.com/*<
>> http://excelmacroworld.blogspot.com/>
>> > *http://noorain-ansari.blogspot.com/*<
>> http://noorain-ansari.blogspot.com/>
>> > On Fri, Oct 14, 2011 at 8:23 PM, prabhat.shrivasta...@gmail.com <
>> >
>> >
>> >
>> > prabhat.shrivasta...@gmail.com> wrote:
>> > > The file need to run on ms excel 2003 version.
>> >
>> > > Rgrds.....Prabhat
>> >
>> > > On Oct 14, 12:03 pm, ashish koul <koul.ash...@gmail.com> wrote:
>> > > > see if it helps
>> >
>> > > > On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com <
>> >
>> > > > prabhat.shrivasta...@gmail.com> wrote:
>> > > > > Good morning experts!!!!
>> >
>> > > > > Need your valueable help to complete ma project, i have three n
>> more
>> > > > > pics in name of ram, shyam, n more pasted on diffrent sheet now i
>> want
>> > > > > if i write ram in a assinged cell ram's pic appear in selected
>> > > > > area
>> of
>> > > > > sheet n so on. I dont wanna use macro for this....i need this to
>> > > > > complete ma project.
>> >
>> > > > > Thanks n regards,
>> > > > > Prabhat Shrivastava
>> >
>> > > > > --
>> >
>> > >
>> ---------------------------------------------------------------------------
>> > > -------
>> > > > > 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 athttp://www.excel-macros.blogspot.com
>> > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > > > > 5. Excel Tips and Tricks athttp://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*
>> > > > * *
>> > > > *Ashish Koul*
>> > > > *http://www.excelvbamacros.com/*
>> >
>> > > > P Before printing, think about the environment.
>> >
>> > > > images_index.xlsx
>> > > > 55KViewDownload
>> >
>> > > --
>> >
>> > >
>> ---------------------------------------------------------------------------
>> -------
>> > > 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 athttp://www.excel-macros.blogspot.com
>> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > > 5. Excel Tips and Tricks athttp://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
>> >
>> >
>> >
>> > Image_Fatching example1.xls
>> > 59KViewDownload
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> ----------------------------------------------------------------------------------
> 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
>
--
Everyday above ground is a good day*****
A proverb is a short sentence based on long experience*****
Water which is too pure has no fish*****
With Regards,
Rudalf.....
--
----------------------------------------------------------------------------------
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
