Return pictures based on cell contents

**okctaxaccountant** · 07-25-2014, 01:53 PM

Hi,

I have inlcuded my workbook that I use for tracking the NFL season and I'd like to add in some team logos just to make it look a little cooler.

The attached workbook includes three sheets, the first of which uses a drop-down for selecting picks. The second sheet has the team logos and the third sheet feeds off the first.

I'd like for team logos to populate into the third sheet based on what is selected in the first sheet.

I've already tried a few methods, all unsuccessfully. I tried this http://www.mcgimpsey.com/excel/lookuppics.html which was a great idea but it didn't allow for the same image to be repeated potentially 100 times. I also tried a method involving named ranges and indirect lookups to the linked picture image but that would require a different named range for every person and every pick which isn't feasible.

I'd love to hear about alternate methods of doing this even if they aren't the prettiest. I was curious if it's possible to just do a massive nested if statement with a vlookup to return an image but I haven't been successful in that either.

Thank you!

**okctaxaccountant** · 07-27-2014, 03:58 PM

Bump for visibility.

Any ideas?

**okctaxaccountant** · 08-01-2014, 10:11 AM

Going to bump this one last time.

Basically all I'm asking... is it possible to display an image in a cell (based on the value of another cell) without

1. Making a new named range for each instance and

2. Using VBA code that just sets an image's visbility to true/false and doesn't allow the image to be repeated throughout the workbook.

**Winon** · 08-01-2014, 12:26 PM

Hello okctaxaccountant,

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

**okctaxaccountant** · 08-01-2014, 03:44 PM

Thank you Winon,

I have included my new workbook with a brief mock-up of what I'm trying to do.

The way I imagine this working is that the BEFORE sheet lets the person make their selection and the AFTER sheet populates the picture based on that selection.