Forum Discussion

yennyg's avatar
yennyg
Copper Contributor
Apr 08, 2022

Images automatic in excel table

I have tables with variable data, I want insert images linked with codes in the table (not from drop drown), if one code changes, the images changes too. 

Attached sample file, the criteria cells are green colored. 

Thank you

Charting
excel
Formulas and Functions

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Apr 11, 2022

    Hi yennyg

     

    there is a concept of linked pictures in Excel: Copy a cell and do a Paste special | Paste linked picture:

     

     

    This way you get a picture that shows the content of the original cell, you can see the reference in the formula bar, when you select the picture:

    As you need to have reference dynamic, you need to create a name for every picture that you need. So in your case, 4 names:

    Instead of a fixed reference, you put in a formula which looks up the code:

    =INDEX(Images!$B$2:$B$14;MATCH(CRITERIA!$G$2;Images!$A$2:$A$14;0))

    =INDEX(Images!$B$2:$B$14;MATCH(CRITERIA!$G$3;Images!$A$2:$A$14;0))

    =INDEX(Images!$B$2:$B$14;MATCH(CRITERIA!$G$4;Images!$A$2:$A$14;0))

    =INDEX(Images!$B$2:$B$14;MATCH(CRITERIA!$G$5;Images!$A$2:$A$14;0))

     

    (Note: Depending on your regional settings it might be that you need to replace ; with , in your formuals)

     

    And then you just replace the fixed reference of the picture with the names that you just defined:

    Now whenever the code in column G of the same row changes, the picture will cange.

     

     

Resources