Vlookup picture

[mr67]

Hello friends
Please someone can guide me on what to do
I have two sheets, inside the first sheet there are two columns, the first column has the serial number and the second column has the content of the photo.
My goal is that in the second sheet, when I enter the serial number in the first column, the relevant image of the first sheet is called in the second column.

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here Picture Lookup in Excel using Named Ranges

 

[mr67]

Hi & welcome to MrExcel.
Have a look here Picture Lookup in Excel using Named Ranges

Hi & welcome to MrExcel.
Have a look here Picture Lookup in Excel using Named Ranges

Hello friend, thank you for your help
But none of these methods work for me
I will upload the file for you, please check and solve my problem, if possible for you
but how can upload an excel file????

 

[Fluff]

If that doesn't work for you, how about Excelguru Help Site - VLOOKUP for Pictures

 

[mr67]

If that doesn't work for you, how about Excelguru Help Site - VLOOKUP for Pictures

Thank you again
Yes, this site says the same thing
And my problem was not solved
Someone can help me?

 

[Fluff]

this site says the same thing

No it doesn't it uses a slightly different technique.

In what way doesn't it work for you?

 

[mr67]

46 / 5,000

Is there anyone here who can write a macro for me?​

 

[mr67]

No it doesn't it uses a slightly different technique.

In what way doesn't it work for you?

Is it possible for me to upload my own file here that you can download and see for yourself ??
If possible, please tell me how to do this

 

[Fluff]

What exactly does this mean

46 / 5,000

You cannot upload files to this site, although you can upload to a share site such as OneDrive, GoogleDrive. Then mark for sharing & post the link you are given to the thread.

 

[mr67]

What exactly does this mean



You cannot upload files to this site, although you can upload to a share site such as OneDrive, GoogleDrive. Then mark for sharing & post the link you are given to the thread.

please check this link:

reference -.xlsx

Refrence Sheet New ردیف,part num,name (EN),name(FA),type,نام کالا,package,rang / part name,diamension,volt / watt,real pic,source,P./N.,buy,diamension pic,PACKING,paking pic,datasheet,website,expalain 2,11030128,Resistor,مقاومت,SMD,SMDمقاومت,1206,0Ω,L:3.2mm±0.2mm W:1.6mm±0.2mm H:0.55±0.15mm C:0....

docs.google.com