Apr 08 2022 06:13 AM
Attached sample file, the criteria cells are green colored.
Thank you
Apr 11 2022 06:27 AM
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.