Dynamic picture based on a reference cell.

[Dme615]

Is there way to have a dynamic picture work in conjunction with vlookup.

I have a sheet that is used to make labels and pulls from a “DATA” sheet. The data sheet has part numbers, suppliers, pictures of parts etc. I would like the picture to change based the reference cell. If I enter 159 in A4, cell f7 would display the picture for part 159 etc.
Due to a large quantity of parts a drop down menu would be a hindrance. And that’s the only way I have found to make it work.

 

[Yongle]

Ok
The method in the video works fine but your part numbers are causing the problem and the lack of consisitency is adding to that problem

 

[Yongle]

Ah we got there together

 

[Yongle]

I need to think about this, but your part numbers are a nightmare!
The obvious thing to do would be to add another column to your table (or a different table) where we give every part a simple consistent alphanumeric reference (which becomes the name of the cell with picture and use VLOOKUP to convert your part numbers to provide that reference
It is not as compliacted as it sounds

How many part numbers are there (approximately)?

Will get back to you on this tomorrow

 

[Dme615]

I need to think about this, but your part numbers are a nightmare!
The obvious thing to do would be to add another column to your table (or a different table) where we give every part a simple consistent alphanumeric reference (which becomes the name of the cell with picture and use VLOOKUP to convert your part numbers to provide that reference
It is not as compliacted as it sounds

How many part numbers are there (approximately)?

Will get back to you on this tomorrow

Unfortunately I’m not in charge of making the part numbers. Simply trying to streamline our process and remove enduser error on the floor.
Approximately 800ish not including when parts combine or are altered and then become a new part number.
May try text join or concatenate later and hide the secondary cell.

 

[Dme615]

Got it!
used concatenate to add _ to part number then name creation. Each name is _xyz.
Used concatenate on label sheet to add _ to part number inputted in and linked the picture name to that cell.
A4= part#
d6 = pic cell
F7= _
d6 formula =concatenate(F7,A4)
Picture name manager=Instead of indirect(a4) use indirect(d6).
Just have to Make sure picture is set to bring forward and it hides the text displayed.

 

[Yongle]

Sounds perfect