Skip to main content

How to insert image or picture dynamically in cell based on cell value in Excel?

In many cases, you may need to insert image dynamically in cell based on cell value. For example, you want the corresponding images to be dynamically changed with the different values you entering in a specified cell. This article will show you how to achieve it.

Insert and change image dynamically based on the values you entering in a cell
Dynamically change image Based On Cell Values With an amazing tool


Insert and change image dynamically based on the values you entering in a cell

As below screenshot shown, you want to display corresponding pictures dynamically based on the value you entered in cell G2. When entering Banana in cell G2, the banana picture will be displayed in cell H2. While entering Pineapple in cell G2, the picture in cell H2 will turn into the corresponding pineapple picture.

1. Create two columns in your worksheet, the first column range A2:A4 contains the name of the pictures, and the second column range B2:B4 contains the corresponding pictures. See screenshot shown.

2. Click Formulas > Name Manager.

3. In the Name Manager dialog box, click the New button. Then the Edit Name dialog pops up, enter Product into the Name box, enter the below formula into the Refers to box, and then click the OK button. See screenshot:

=INDIRECT(ADDRESS(2-1+MATCH(Sheet2!$G$2, Sheet2!$A$2:$A$4, 0), 2))

Notes:

1). In the formula, the first number 2 is the row number of your first product. In this case, my first product name locates in row 2.
2). Sheet2!$G$2 is the cell you want to make the corresponding image changed dynamically based on.
3). Sheet2!$A$2:$A$4 is your list of product names in current worksheet.
4). The last number 2 is the column number containing your images.

You can change them as you need in the above formula.

4. Close the Name Manager dialog box.

5. Select a picture in your Pictures column, and press Ctrl + C keys simultaneously to copy it. Then paste it to a new place in current worksheet. Here I copy the apple picture and place it in cell H2.

6. Enter a fruit name such as Apple in cell G2, click to select the pasted picture, and enter formula =Product into the Formula Bar, then press the Enter key. See screenshot:

From now on, when changing to any fruit name in cell G2, pictures in cell H2 will turn into corresponding one dynamically.

You can pick the fruit name quickly by creating a drop-down list containing all fruit names in cell G2 as below screenshot shown.


Easily insert images to related cells based on cell values with an amazing tool

For many Excel newbies, the above method is not easy to handle. Here recommend the Picture Drop-down List feature of Kutools for Excel. With this feature, you can easily create a dynamic drop-down list with values and pictures totally matching.

Before applying Kutools for Excel, please download and install it firstly.

Please do as follows to apply the Picture Drop-down List feature of Kutools for Excel to create a dynamic picture drop-down list in Excel.

1. Firstly, you need to create two columns separately containing the values and its corresponding pictures as the below screenshot shown.

2. Click Kutools > Import & Export > Match Import Pictures.

3. In the Picture Drop-down List dialog box, you need to configure as follows.

3.1) If you have created the values and pictures columns in step 1 above, please ignore this step;
3.2) In Step2 section, select the two columns you have created;
3.3) In Step3 section, select the range to output the dynamic picture drop-down list.
Note: In Step3 section, you need to select two columns for placing the results. One column is for values and another is for the corresponding pictures.
3.4) Click OK.

4. Then a Kutools for Excel dialog box pops up to reminds you that some intermediate data will be created during the process, click Yes to continue.

Then a dynamic picture drop-down list is created. The picture will change dynamically based on the item you selected in the drop-down list.

Click to know more about this feature...

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Related articles:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (15)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Can this be paired up with excel Queries?
This comment was minimized by the moderator on the site
Hi Maxem,
The methods can't be paired up with Excel queries, and I have not been able to fix the problem. Sorry for the inconvenience.
This comment was minimized by the moderator on the site
What if the cell value we take to change the picture has more than one word. Like a company name and logo
This comment was minimized by the moderator on the site
How can I, if no value is entered, reset to a defaut image (or nothing)?Thanks
This comment was minimized by the moderator on the site
Hi Admin
Thanks for sharing very good article. Could you please tell me, In Ist procedure step 6, I want to enter value for G2 through a user form. Is it possible? Please help
This comment was minimized by the moderator on the site
Good day,
Sorry, the user form does not take into consideration in this case.
This comment was minimized by the moderator on the site
Could this be used instead of conditional formatting icon sets?
I need a green down arrow and red up arrow based on percentages from other cells.


If so, how would I go about completing this?

I'm needing negative percentages (<0%) to show a red up arrow,
Neutral percentages (=0%) to show a yellow bracket. (can already be done with conditional formatting),
Positive percentages (>=0.001%) to show a green down arrow.



How would I achieve this?
This comment was minimized by the moderator on the site
Dear Jason,
Sorry i don't have methd for this question.
This comment was minimized by the moderator on the site
Looks really great! But I need it to auto fill a cell (B1) with a picture when I type something in cell A1. Is this possible? and can we change max file count in folder? Have one with 15.000 pics, max is 10000.

Thanks! Love to hear from you@!
This comment was minimized by the moderator on the site
Guido, the problem you mentioned cannot be solved. Sorry about that!
This comment was minimized by the moderator on the site
Can you please tell, how can this be looped for over 600 rows. Here in this tutorial, it changes picture based on only one cell, I need the same for multiple cells, do I need to make separate "Product" lists for that in "Name Manager", because that lists is over 600.
This comment was minimized by the moderator on the site
Dear Nick,

Sorry to tell you that this method can't be looped for multiple cells. You need to specify =Product formula to all needed pictures one by one manually in your case.
Thank you for your comment!
This comment was minimized by the moderator on the site
This is awesome, is there a way of creating a lookup formula on another worksheet that will look up the name and return the picture into the selected cell?
This comment was minimized by the moderator on the site
Hey Nick did you get how to do it, when you want to have the list of the pictures on other sheet?
This comment was minimized by the moderator on the site
Great article, really helpful for something I'm trying to do. How would you change the formula in step 3 if all of the images and names were on another worksheet? Many thanks.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations