Adding an Image with a twist

[Buddhaboy32]

Good Day,

I have designed this spread sheet / database in excel with some help from my acquaintances on this site.

Thank you once again for the help, the database / spreadsheet works well.

I have one last ambition - that is to add an image on the right (as below) from the spreadsheet.

Now comes the Twist

The image needs to change to the corresponding CODE of nozzle.

(E.G: if the CODE is "FCT-80-0,5-CER" or "FCT-80-5-CER" the image must remain the same,

however if the CODE changes to "FCT-IA-01-CER" or "FCT-IA-025-CER" then the image needs to change to the corresponding image as below.)

Please advise,

Greatly Appreciated.

 

[Tricepsratops]

I've done something like this before, but it is a tedious process if you need multiple pictures. The video below explains the method I used.

 

[mikerickson]

In the OP do you have two images or four.
If there are 4, then it looks like "FCT-IA-01-CER" or "FCT-IA-025-CER" are both associated with the same image.

 

[Buddhaboy32]

In the OP do you have two images or four.
If there are 4, then it looks like "FCT-IA-01-CER" or "FCT-IA-025-CER" are both associated with the same image.

Hi, it is only 2 images

 

[mikerickson]

If there are two images, then why would switching from "FCT-IA-01-CER" to "FCT-IA-025-CER" cause a change in image? Different colors?

How can one tell which image goes with which Code?

 

[Buddhaboy32]

If there are two images, then why would switching from "FCT-IA-01-CER" to "FCT-IA-025-CER" cause a change in image? Different colors?

How can one tell which image goes with which Code?

Hi,

I want the images to change when the CODE changes in the 1st Screenshot from FCT-IA-01-CER to FCT-CH-80-05-CER, they are 2 different types on products,

However if the CODE only changes From HCT-IA-01-CER to FCT-IA-03, then the image must be the same.

If you view the 2nd Screenshot - B4 : B10 is one group with 1 Image and B13 : B20 is one group with another Image

So, If the CODE changes in the 1st Screenshot to HCT-IA-01-CER then it needs to = image 1 in the 2nd Screenshot ( Green Nozzle) and if the CODE changes in the 1st Screenshot to
FCT-01-CER the it need to = Image 2 in the 2nd Screenshot (Red Nozzle), BUT if the CODE in the 1st Screenshot only changes From HCT-IA-01-CER to HCT-IA-03-CER then it still needs to = image 1 in the 2nd Screenshot ( Green Nozzle)

Hope it makes better sense now.