+ Reply to Thread
Results 1 to 3 of 3

Change dynamically a picture on a worksheet based on a value from a dropdown list

  1. #1
    Registered User
    Join Date
    12-25-2017
    Location
    China
    MS-Off Ver
    Microsoft Office standard 2013
    Posts
    2

    Change dynamically a picture on a worksheet based on a value from a dropdown list

    Hi,

    I would like to change dynamically a picture on a worksheet based on a value from a dropdown list. I found online 2 ways that seems to fit my problem. However, I can't seem to make either of them work.

    My dropdown list is located on my first worksheet named "Product Dashboard" in cell D20.
    It refers to a list of bottle names in another worksheet called "Bottle" in cell: "A2:A50"
    In the same worksheet "Bottle" in cell: "K2:K50" I have a serie of bottle picture corresponding to the bottle names of A2:A50.
    I would like to make the bottle picture corresponding to the value in the drop down list appear dynamically approximatley around the L20:N26 area in the "Product Dashboard" worksheet.

    See pictures enclosed.Excel question sc 1.jpgExcel question sc 2.jpg

    the 2 methods that I found online and can basically understand involve named range:
    https://exceloffthegrid.com/automati...hange-picture/
    https://www.extendoffice.com/documen...e-in-cell.html

    in Formula/new name, I tried to define a new range "Bottleimagelookup" referring to either one of these 2 formulas:

    =INDEX(Table1[Picture],MATCH('Product Dashboard'!$D$20,+Table1[Bottle Name],0))

    or

    =INDIRECT(ADDRESS(2-1+MATCH('Product Dashboard'!$D$20,+Table1[Bottle Name], 0), 11))

    However, each time, excel tells me: "We found a problem with this formula. Try clicking Insert Function ,etc." (see picture enclosed).Excel problem sc.PNG

    Do you know what is it that I am doing wrong? Would you know how to correct the formulas above or have a way that could solve my initial problem?

    Thanks in advance for you help!

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Change dynamically a picture on a worksheet based on a value from a dropdown list

    a source in russian

  3. #3
    Registered User
    Join Date
    12-25-2017
    Location
    China
    MS-Off Ver
    Microsoft Office standard 2013
    Posts
    2

    Re: Change dynamically a picture on a worksheet based on a value from a dropdown list

    Thank you for your feedback. I guess it's good to have multiple resources in the same place with your link and the links that I posted above together. I wish I spoke russian though...

+ 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. Change multiple cells based on dropdown list value.
    By NKuip in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2017, 02:34 AM
  2. [SOLVED] Raffle Draw: Dynamically changing the picture based on the formula
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-27-2017, 03:37 AM
  3. Replies: 11
    Last Post: 01-20-2015, 09:34 AM
  4. [SOLVED] Dynamically change X-axis as per dropdown selection
    By Sai Prashanth in forum Excel General
    Replies: 3
    Last Post: 09-12-2014, 05:20 PM
  5. Select Picture via Dropdown list
    By cmlucifer in forum Excel General
    Replies: 6
    Last Post: 01-21-2014, 02:51 PM
  6. Display result dynamically & automatically based on dropdown
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2013, 02:07 AM
  7. Replies: 21
    Last Post: 12-02-2009, 03:27 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