Index and Match (or other formula) Inserting an image instead of text

[Joneye]

Hi All

Below is the data table which would have an image in it (C1), in another tab, ill have a drop down list of names, when the name is selected what I would like is to see the image appear after the name.

I tried index and match and it reported back N/A, is there another forulm I should look into that may look up the name and bring in the image ?

A1	B1	C1
NAME	AGE	PHOTO
Jane Doe	33	(There will be a head shot here)
Jon Doe	45	(There will be a head shot here)

 

[Eric W]

Check this out:

Picture Lookup in Excel using Named Ranges

Learn how to use Named Ranges to do a Picture Lookup in Excel. This is a cool excel dashboard trick where pictures update dynamically based on selections

trumpexcel.com

 

[Joneye]

Check this out:

Picture Lookup in Excel using Named Ranges

Learn how to use Named Ranges to do a Picture Lookup in Excel. This is a cool excel dashboard trick where pictures update dynamically based on selections

trumpexcel.com

I was half way there, just needed to condition the cell, lesson learned, thanks for your help

 

[Eric W]

Happy to help!