ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VLOOKUP- use a picture (https://www.excelbanter.com/excel-discussion-misc-queries/85883-vlookup-use-picture.html)

honyacker

VLOOKUP- use a picture
 
I have the formula:

=VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)

Where in the destination cell, I want a picture.
In other words, instead of taking the text "See Diagram", I want my actual
picture in there.
Is it possible?
Thanks,
Joe



JE McGimpsey

VLOOKUP- use a picture
 
See

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

In article ,
"honyacker" wrote:

I have the formula:

=VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)

Where in the destination cell, I want a picture.
In other words, instead of taking the text "See Diagram", I want my actual
picture in there.
Is it possible?
Thanks,
Joe


Ron Coderre

VLOOKUP- use a picture
 
The VBA solution provided by JE McGimpsey is the generally accepted best
approach:

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


Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"honyacker" wrote:

I have the formula:

=VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)

Where in the destination cell, I want a picture.
In other words, instead of taking the text "See Diagram", I want my actual
picture in there.
Is it possible?
Thanks,
Joe




honyacker

VLOOKUP- use a picture
 
Thank you. Exactly what I want.

Joe


"honyacker" wrote in message
...
I have the formula:

=VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)

Where in the destination cell, I want a picture.
In other words, instead of taking the text "See Diagram", I want my actual
picture in there.
Is it possible?
Thanks,
Joe






All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com