| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Picture from dropdown selection | New Users to Excel | |||
| insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
| vlookup and picture | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Hybrid Mode
