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]

That link comes back as "unauthorized"

 

[mr67]

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

If you open the file, you will see two sheets
I want each code I entered in the first column of the second sheet to bring the image corresponding to that code from the first sheet
Can you do this in my file using the methods you sent me?
I could not do that

 

[Fluff]

See post#11

 

[mr67]

See post#11

Sorry
Please check this link again

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

 

[Fluff]

Thanks for that, but with that many images, the methods I linked to are not going to be feasible.

 

[mr67]

Thanks for that, but with that many images, the methods I linked to are not going to be feasible.

Thanks ,
Do you know anyone who can do this for me?

 

[Fluff]

You would need VBA, but I've never really used images, so cannot help, but hopefully somebody else will step in.

 

[mr67]

You would need VBA, but I've never really used images, so cannot help, but hopefully somebody else will step in.

Anyway,
thank you for all your efforts

 

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

There is someone who knows macro writing to help me do this؟؟؟؟؟