Can images be incorporated into a lookup formula?
 

We have several different logos for each of our companies. Based on which
plant is selected from a pull down table, I would like to have that logo
displayed. Is this possible?

Can images be incorporated into a lookup formula?
 

Maybe you could do something like JE McGimpsey does at:
http://www.mcgimpsey.com/excel/lookuppics.html

DNR wrote:

We have several different logos for each of our companies. Based on which
plant is selected from a pull down table, I would like to have that logo
displayed. Is this possible?

--

Dave Peterson

Can images be incorporated into a lookup formula?
 

To have a picture show up based on VLOOKUP when you select an item from a DV
list or type in a name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed and the
pictures must be stored on the same worksheet as the VLOOKUP formula.

Or you need multiple pictures shown from VLOOKUPS.............

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures via selections.

Allows for more than one picture to be displayed on a sheet but also
requires
the pictures be stored on same sheet.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 12:35:02 -0700, DNR
wrote:

We have several different logos for each of our companies. Based on which
plant is selected from a pull down table, I would like to have that logo
displayed. Is this possible?