VLOOKUP issue

[The Great Attractor]

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.

 

[Gord Dibben]

Maybe you can employ event code and VLOOKUP with Data Validation list selection
to choose which picture to show?

See JE McGimpsey's site for more on lookuppics.

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


Gord Dibben MS Excel MVP

 

[The Great Attractor]

Maybe you can employ event code and VLOOKUP with Data Validation list selection
to choose which picture to show?

See JE McGimpsey's site for more on lookuppics.

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


Gord Dibben MS Excel MVP

Thank you. I will look it over, and give it a try.

Did you look at my posted screen shot at all?

 

[The Great Attractor]

Maybe you can employ event code and VLOOKUP with Data Validation list selection
to choose which picture to show?

See JE McGimpsey's site for more on lookuppics.

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

I tried that with a little variant, and it works great.

It seems the drop down list is not happy with my 110,000 row selection
list, but I do not need that data validation to get the lookup.

I do have to "place" the photo file ON my main worksheet though. I
wish I could grab them from the PicTable worksheet. It appears that the
macro merely places the specified picture # from the current sheet.

It would be nice if I could get it to grab it from the lookup table
itself. I'll work on trying to point the macro to pictures stored in that
sheet. I have posted another screenshot in alt.binaries.misc for anyone
that is interested in seeing my DVD database progress.

It is titled: DVD Database Screen shot.

 

[Gord Dibben]

No.

I don't deal with any binary groups and feel no need to start.


Gord

 

[The Great Attractor]

Is there any way you could visit the link you posted for me and look at
that Visual Basic macro to see if there is anything I could do to make it
point to images gathered in another sheet, as opposed to having to place
them all on my main view sheet?

As it stands, all the images that it pulls from need to be on the sheet
it places them into my desired cell location. I would rather pull them
off the sheet that has the indexed reference, or even another workbook,
which would act as an image database table of sorts.

 

[The Great Attractor]

Is there any way you could visit the link you posted for me and look at
that Visual Basic macro to see if there is anything I could do to make it
point to images gathered in another sheet, as opposed to having to place
them all on my main view sheet?

As it stands, all the images that it pulls from need to be on the sheet
it places them into my desired cell location. I would rather pull them
off the sheet that has the indexed reference, or even another workbook,
which would act as an image database table of sorts.

Here is the code segment:

Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("F1")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub

Looks like I could just change where "Me.Pictures" is referenced
from/to.