Link text and picture

Hello, Is there a way for me that when I type "Product 1" in column C and "A" in column D and then the picture of the product1A pops up in column F.
This would help me save my time a lot as i dont have to add every picture manually.
My file is in this post.
Thank you very much