Forum Discussion
VLookup to an image in excel
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!
- Please refer to this link for instructions:
https://www.computergaga.com/blog/create-a-picture-lookup-in-excel/- 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
