Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 1st 07, 02:52 AM posted to microsoft.public.excel.worksheet.functions
ah ah is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 33
Default how do I insert picture into cell so vlookup can return picture?

I have a table in excel containing names of products and their pictures.

On another worksheet, I want to select the name of the product from a
drop-down list and have the adjacent cell display the image from the product
picture table.

Excel does not imbed the picutures into the cells. Is there any way to do
this so you can use vlookup? or is there a better way of approaching this?

  #2   Report Post  
Old May 1st 07, 04:38 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default how do I insert picture into cell so vlookup can return picture?

Take a look he

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


In article ,
ah wrote:

I have a table in excel containing names of products and their pictures.

On another worksheet, I want to select the name of the product from a
drop-down list and have the adjacent cell display the image from the product
picture table.

Excel does not imbed the picutures into the cells. Is there any way to do
this so you can use vlookup? or is there a better way of approaching this?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert a picture in to a comment but picture not save on hard disk Pablo Excel Discussion (Misc queries) 0 February 21st 07 04:48 PM
Cell value becomes filepath to insert picture,jpg or object Rookie_User Excel Worksheet Functions 0 February 6th 07 05:32 PM
how to insert picture to the cell? Johney Salem Excel Discussion (Misc queries) 2 January 23rd 06 05:58 PM
How to insert picture and automatically size to cell? ursa_nz Excel Worksheet Functions 1 August 22nd 05 03:29 AM
how can I insert a picture conditional on another cell Boyd Excel Worksheet Functions 2 December 15th 04 09:25 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017