+ Reply to Thread
Results 1 to 6 of 6

Dynamic pictures

  1. #1
    Forum Contributor colddeck84's Avatar
    Join Date
    06-18-2016
    Location
    bergen, norway
    MS-Off Ver
    2016
    Posts
    254

    Dynamic pictures

    Hi guys I hope some of you excel ninjas could help me out:


    Basically I have a drop down menu with diffrent countries: and I have a dropdown list with them sorted, Basically I want a country flag next to selected country.
    https://imghost.io/images/2017/02/26/heeeelp.png

    It works perfectly for line 4, here is the code I used in formulas: "flagpic" =INDEX(Sheet2!$S$4:$S$6;MATCH(Sheet2!$D$4;Sheet2!$R$4:$R$6;0))

    The problem Im having is when I try to add a new "line 5" the flag does not change based on D5 value but d4s value. what can I do to fix this ?

    any help i would appricate
    Last edited by colddeck84; 02-26-2017 at 08:43 AM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Dynamic pictures

    Just a suggestion as I can't test - remove the Absolute Reference to D4 ( Remove the $ before the row/column reference)/

  3. #3
    Forum Contributor colddeck84's Avatar
    Join Date
    06-18-2016
    Location
    bergen, norway
    MS-Off Ver
    2016
    Posts
    254

    Re: Dynamic pictures

    i updated to this: =INDEX(Sheet2!$S$4:$S$11;MATCH(Sheet2!D4;Sheet2!$R$4:$R$11;0))

    but now nothing works

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Dynamic pictures

    Sorry about that but like I said, it just a suggestion as I'm using a phone and can't test anything.
    Last edited by cytop; 02-26-2017 at 09:39 AM. Reason: Phone spelling howlers

  5. #5
    Forum Contributor colddeck84's Avatar
    Join Date
    06-18-2016
    Location
    bergen, norway
    MS-Off Ver
    2016
    Posts
    254

    Re: Dynamic pictures

    thanks anyway, i guss i will get a headace with this one ....

  6. #6
    Forum Contributor colddeck84's Avatar
    Join Date
    06-18-2016
    Location
    bergen, norway
    MS-Off Ver
    2016
    Posts
    254

    Re: Dynamic pictures

    here is the file if that makes it easier to review:

    http://www.filedropper.com/sample_18

+ 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. How to remove hyperlink to pictures in excel and retain the pictures?
    By london7871 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2016, 11:24 PM
  2. Replies: 1
    Last Post: 05-02-2014, 06:18 AM
  3. Project management and pictures, basically make a day planner with pictures
    By Axe Doctor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-10-2012, 12:58 PM
  4. Insert/Delete Multiple Pictures but 1 or more pictures not available
    By MrNoodles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 02:10 PM
  5. [SOLVED] Pictures.Visible question (after adding many pictures, they stop disappearing)
    By Abe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 01:35 PM
  6. Replies: 1
    Last Post: 01-29-2006, 02:50 AM

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