How to give cell address to an image in excel ?

[Aditi]

[FONT=&quot]Hi,
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I developed a large database in excel(sheet 1). My objective is to extract only specific data and images (sheet2) from this large data (sheet 1).
[/FONT]
[FONT=&quot]I used dget function to extract data, but dget function does't work to extract images as they dont have any cell address.
[/FONT]
[FONT=&quot]Above is a screen shot. If i type FC in other sheet , the image related should be displayed.
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]1. How to give cell addres to the images. Images are floating on the cell and i could't use them in formulas as they dont have any specific address ?
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]2. What are the ways to extract images to other sheet ?[/FONT]

 

[Scott T]

The video in the link below shows how to lookup a picture

https://youtu.be/CEM0pp5SjMU