LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default VLOOKUP issue


Hi Guys ('N' Gals),

I have a huge worksheet that has about twelve sheets in it, each with
only two columns. One is the ID, and the other some unique data.

I have a "Master View Panel" sheet in which I do a set of VLOOKUPs for
each "field" (cell) in the master sheet. All is well.

I have one lookup that I want to use, but am having trouble with.

I want a group of cells that I have merged together in the master panel
in the shape of a portrait sized block to reference to my "Image_Pointer"
worksheet. I want to place a pointer in that sheet that points to a jpeg
photo file, and have the master sheet insert the photo based on the
record currently being viewed in the ID cell and all the other cells.

All the other cells fill fine, but I do not know how to auto-insert a
photo or clipart item by way of a lookup (VLOOKUP or otherwise).

Does anyone know how to do this in a spreadsheet, or is my only hope an
Access database or other view method for the data?

I have a directory with the images in it, and can even make the cell a
hyperlink, but the VLOOKUP only fills in the cell with the active
hyperlink, and not the actual image.

I am bummed, because I want to do this in excel, and NOT have to work
up a database.

I posted a screenshot (191 kB) in alt.binaries.misc called:

"DVD Database Screenshot for Doug"

It is of the master view panel, and the blank area is where I want to
paste an image on a per record basis.

Thank you in advance for any assistance in this regard.
 
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
VLOOKUP Issue Rocco2526 Excel Worksheet Functions 2 December 3rd 08 08:54 PM
vlookup issue Joe Excel Worksheet Functions 1 October 5th 06 07:33 PM
VLOOKUP issue Jonah Excel Worksheet Functions 1 November 16th 05 10:54 PM
VLOOKUP issue Jonah Excel Worksheet Functions 0 November 16th 05 10:31 PM
VLOOKUP ISSUE Hardip Excel Worksheet Functions 2 March 23rd 05 08:11 AM


All times are GMT +1. The time now is 03:54 PM.

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

About Us

"It's about Microsoft Excel"