![]() |
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 |
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 |
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 |
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