Personal picture

[John 4348]

Hello everyone
I have 2 sheets. On Sheet 1, in columns A:H, l have personal information of my students. In A2:A22, names, in B2:B22, personal pictures and ....
On sheet 2 in C1 cell, I have a drop- down list of names from sheet 1.
Is there a way to link between pictures in sheet 1 & drop down list to show personal pictures?

 

[NdNoviceHlp]

Hi John 4348. You can look here... How to pop up an image on another worksheet?
HTH. Dave

 

[Eric W]

There are a few ways to do this. Google "Excel VLOOKUP pictures". Here's one link:

Picture Lookup in Excel | Computergaga

Many Excel users know how to use lookup functions to return values. But in this tutorial, we see how to create a picture lookup in Excel.

www.computergaga.com

 

[John 4348]

Hi John 4348. You can look here... How to pop up an image on another worksheet?
HTH. Dave

Hi HTH.Dave
Thank you.

 

[John 4348]

There are a few ways to do this. Google "Excel VLOOKUP pictures". Here's one link:

Picture Lookup in Excel | Computergaga

Many Excel users know how to use lookup functions to return values. But in this tutorial, we see how to create a picture lookup in Excel.

www.computergaga.com

Hello
Thank you

 

[Peter_SSs]

Hello
Thank you

The marked solution has been changed accordingly.
In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[John 4348]

The marked solution has been changed accordingly.
In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

All right.