Images automatic in excel table

Copper Contributor

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

1 Reply

Hi @yennyg

 

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

DTE_0-1649683061233.png

 

 

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:

DTE_1-1649683318398.png

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:

DTE_2-1649683397224.png

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:

DTE_3-1649683536226.png

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