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

Sorry for late reply and thank you for your answer. The pictures stored in drive D (D: > Picture Name).
I have never used VBA before so I googled a bit and found it very hard tbh