Built the table - no problem

Col. A has a three char. code
Col. B has the logo (insert picture) completely inside the cells
Named Range is LTBL for the entire table

With the picture link still selected, change its formula to =LOGO1
Got to this step and may have misunderstood...
I did enter, literally =LOGO1 in the formula window of the selected pic.
When this didn't work, I also changed it to the three char code from the
table, but that didn't work either...

define the name LOGO1 as
=INDEX(LTBL,MATCH($X$99,INDEX(LTBL,0,1),0),2)
Not sure what you mean by define the name "LOGO1"
I did change the reference to $A$2, where my first image appears

What have I missed...?

Thanks!
Ray



"Harlan Grove" wrote:

"RayportingMonkey" wrote...
I need to display a number of corporate logos on a report I am creating. The
report(s) run from a single template, so I want to be able to DISPLAY (not
hyperlink) the appropriate logo, based on a cell's content.

Is this even possible?

Yes, but it's fragile, i.e., easily broken/screwed up. You could create a
table with wider than usual columns and taller than usual rows. Enter
distinct identifying strings in the first column and insert the logo images
ENTIRELY inside the cells in the second column. Name that table (spanning the
two columns and all its rows) LTBL.

Then in the worksheet where you want the logos to appear, copy a cell, hold
down a [Shift] key and click on Edit in the menu, then click on Paste Picture
Link. With the picture link still selected, change its formula to =LOGO1. If
the cell that gives the identifier for the first logo were X99, define the
name LOGO1 as

=INDEX(LTBL,MATCH($X$99,INDEX(LTBL,0,1),0),2)

The picture link should now appear as the logo corresponding to the value of
X99.

You could copy and paste the picture link repeatedly and place the copies
wherever you want them. Then change them to refer to different defined names:
LOGO2, LOGO3, LOGO4, etc. Then define these names using the formula above but
changing $X$99 to the appropriate cell containing the identifier.

YOU have to ensure that YOU use the same identifying text in LTBL that
already appears in your display worksheet.