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.

[TABLE="width: 705, align: left"]
<tbody>[TR]
[TD]SKU[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD]Picture[/TD]
[TD][/TD]
[TD]SKU[/TD]
[TD]Part Number[/TD]
[TD]Matching Named Range[/TD]
[TD]Photo[/TD]
[/TR]
[TR]
[TD="align: right"]99243[/TD]
[TD]36-244[/TD]
[TD]_36-244[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]99243[/TD]
[TD]36-244[/TD]
[TD]_36-244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11024[/TD]
[TD]46-244[/TD]
[TD]_46-244[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]11024[/TD]
[TD]46-244[/TD]
[TD]_46-244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]668755[/TD]
[TD]56-244[/TD]
[TD]_56-244[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]652498[/TD]
[TD]66-244[/TD]
[TD]_66-244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]652498[/TD]
[TD]66-244[/TD]
[TD]_66-244[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]112355[/TD]
[TD]72-244[/TD]
[TD]_72-244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]112355[/TD]
[TD]72-244[/TD]
[TD]_72-244[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]998866[/TD]
[TD]TC-158[/TD]
[TD]TC-158[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]998866[/TD]
[TD]TC-158[/TD]
[TD]TC-158[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]12351[/TD]
[TD]36-LD-244[/TD]
[TD]_36-LD-244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12351[/TD]
[TD]36-LD-244[/TD]
[TD]_36-LD-244[/TD]
[TD]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[TD="align: right"]668755[/TD]
[TD]56-244[/TD]
[TD]_56-244[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.