Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP Issue | Excel Worksheet Functions | |||
vlookup issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP ISSUE | Excel Worksheet Functions |