Index Match Pictures Or VBA Match Pictures

[arembr01]

I have a spread sheet with hundreds of part numbers, SKU, and matching photos. I need to be able to show the correct image based on the SKU. It can be index match, vba, vlookup, I'm find with anything. The only things I've been able to find online use a drop down list and this will not work for me because I have so many parts I need to match up. I'd to be able to paste data into the look up portion and the sheet update with the correct pictures.

I'll try to attach a sample sheet. I don't see how to attach a file. So far I've created defined names that match to the photos. I can't get anything to work beyond that. Thank you for your help.

SKU	Name		Picture		SKU	Part Number	Matching Named Range	Photo
99243	36-244	_36-244	<tbody> </tbody>		99243	36-244	_36-244
11024	46-244	_46-244	<tbody> </tbody>		11024	46-244	_46-244
668755	56-244	_56-244	<tbody> </tbody>		652498	66-244	_66-244
652498	66-244	_66-244	<tbody> </tbody>		112355	72-244	_72-244
112355	72-244	_72-244	<tbody> </tbody>		998866	TC-158	TC-158
998866	TC-158	TC-158	<tbody> </tbody>		12351	36-LD-244	_36-LD-244
12351	36-LD-244	_36-LD-244	<tbody> </tbody>		668755	56-244	_56-244

<tbody>
</tbody>

 

[Scott T]

This video shows how to lookup a picture.
https://youtu.be/CEM0pp5SjMU

 

[arembr01]

That video shows you how to do it if you have a drop down and need to select only 1 picture. I have 100's of pictures that need to me matched with 100's of parts.

I need to be able to do this where I can drag the formula down and apply it to 100's of these.

 

[arembr01]

That video shows you how to do it if you have a drop down and need to select only 1 picture. I have 100's of pictures that need to me matched with 100's of parts.

I need to be able to do this where I can drag the formula down and apply it to 100's of these.


If someone could use VBA to change the name references. For example changing =Sheet1!$I$4 to this =indirect(Sheet1!$I$4) in the name manager. If I could do that it would work just fine. I would need to change each one for all the names located within that specific column.

 

[Scott T]

The data validation does not change anything. You can do what is shown in the video without data validation and it will work if you type in a valid product.

 

[arembr01]

The data validation does not change anything. You can do what is shown in the video without data validation and it will work if you type in a valid product.

Perhaps I'm not doing a good job of explaining or I don't understand you. It is my understanding that the video link you provided works for selecting 1 image based on a drop down selection. I downloaded the file prior to posting in here.

I will have a list of 100's of part numbers and I need to match an image to each part number, all the same time. I want to be able to paste a new list of part numbers and get new matching images.

If someone was able to create the code that would change a name manager reference to =indirect(sheet1!$A$1)

I just need to have "indirect()" added to the existing reference for 1 specific column.