VLookup to an image in excel

[skendzi]

Hello,

I want to create a sheet in excel that houses 2 columns of data:

1. 10 digit item code

2. Photo of the 10 digit item code

In a separate sheet, I want to be able to reference the 10 digit item code in column 1 and have it populate with the image in column 2. 

I figured the best way to go about this would be through a VLookup, but can't seem to figure out how to link text with an image and reference it through a VLookup. 

Any tips/tricks appreciated.

Thanks!

[#2]

Please refer to this link for instructions:
https://www.computergaga.com/blog/create-a-picture-lookup-in-excel/

[#3]

how do you get this to work for every cell? when i try to do this on the cells below it just copies the first picture instead of bringing up the new one assigned to a different number.

im making a list so id like to be able to do this for multiple rows