+ Reply to Thread
Results 1 to 4 of 4

Return picture (indirect function)

  1. #1
    Registered User
    Join Date
    06-18-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    16

    Return picture (indirect function)

    Hi, I try to link the text with the picture for example when I type apple, the apple picture pops up. I have finished that with the name manager function but still have a problem.
    My problem is the number of pictures must be exactly the same as the number of pictures that I link. In my file, I have three pictures; apple, banana, and pineapple. If there are only 3 cells in column (G,H), it would work perfectly fine, but if i add more cells such as 4 or 5, it does not work for picture 4 and 5.

    My solution to this is adding random pictures in the source in order to have more number of pictures in the source and it will work with the limitation of number of pictures in the source.

    But I want to have a better solution to this problem, my solution will take me a lot of time. What should I do.
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,000

    Re: Return picture (indirect function)

    1. Add another named range for Fruit4
    =INDIRECT(Sheet1!$I$6)

    2. Change G6 to =Fruit4

    repeat as needed.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    06-18-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    16

    Re: Return picture (indirect function)

    It works, Thank you very much!!! Glenn Kennedy.
    Can I ask you another question. As I have to copy the picture in column B(Source) to column G(Linked Picture) by using special paste(special paste > Linked picture), it allows me to paste only 1 picture per cell. How can I paste(special paste) a lot of pictures to many cells in column G in one time paste?

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,000

    Re: Return picture (indirect function)

    Others: please jump in. I'm away for most of the day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If Function, Indirect & Vlookup to return based on two requirements
    By elouise_everett in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-04-2017, 04:44 AM
  2. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  3. COUNTIFS and INDIRECT function return #VALUE error - don't know why?
    By MikeRoot in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2014, 02:37 PM
  4. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  5. [SOLVED] Indirect function in a picture
    By MaxOtis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2013, 11:54 PM
  6. Using Indirect function to return a named range.
    By adrianodl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 09:30 AM
  7. [SOLVED] Return a picture using IF formulas
    By T Williams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1