Hey guys,

Why does vlookup not carry an image over from a cell that is polled in
a lookup?

Also, what type of lookup function can be used to grab that cell's image
if not vlookup?

Bottom line answer? No function I'm aware of will bring a graphic from one
sheet into another, it takes some VB coding to do it.

"AtTheEndofMyRope" wrote:

Hey guys,

Why does vlookup not carry an image over from a cell that is polled in
a lookup?

Also, what type of lookup function can be used to grab that cell's image
if not vlookup?

On Sun, 30 Aug 2009 06:06:01 -0700, JLatham
wrote:

Bottom line answer? No function I'm aware of will bring a graphic from one
sheet into another, it takes some VB coding to do it.

"AtTheEndofMyRope" wrote:

Hey guys,

Why does vlookup not carry an image over from a cell that is polled in
a lookup?

Also, what type of lookup function can be used to grab that cell's image
if not vlookup?


I guess then that it would be nice to grab the cell setting, as in what
the image got scaled to, so that it can be called directly from the file,
and then scaled to match. I had a dvd database that was doing it pretty
nicely, but all the images were the same size and type.
Another strange thing is that it does allow "cut and paste" to carry it
over.

So, I need to code to find the cell location, and then perform an
explicit cut and paste operation based on the cell that was resolved by
the logic functions.

Can I do that without VB?

That is, perform a lookup just like vlookup would, and then perform a
cut and paste based on the result of the lookup.

I know this steps outside the sheet calculate/refresh engine so I would
have to define a button or such for doing the copy and paste.

Any thoughts?

I will repeat...............the image is not "in the cell".

Any cut and paste of an image must be done manually or through VBA.

John's lookuppics can be utilized.


Gord Dibben MS Excel MVP

On Sun, 30 Aug 2009 08:53:46 -0700, AtTheEndofMyRope
wrote:

On Sun, 30 Aug 2009 06:06:01 -0700, JLatham
wrote:

Bottom line answer? No function I'm aware of will bring a graphic from one
sheet into another, it takes some VB coding to do it.

"AtTheEndofMyRope" wrote:

Hey guys,

Why does vlookup not carry an image over from a cell that is polled in
a lookup?

Also, what type of lookup function can be used to grab that cell's image
if not vlookup?


I guess then that it would be nice to grab the cell setting, as in what
the image got scaled to, so that it can be called directly from the file,
and then scaled to match. I had a dvd database that was doing it pretty
nicely, but all the images were the same size and type.
Another strange thing is that it does allow "cut and paste" to carry it
over.

So, I need to code to find the cell location, and then perform an
explicit cut and paste operation based on the cell that was resolved by
the logic functions.

Can I do that without VB?

That is, perform a lookup just like vlookup would, and then perform a
cut and paste based on the result of the lookup.

I know this steps outside the sheet calculate/refresh engine so I would
have to define a button or such for doing the copy and paste.

Any thoughts?

On Sun, 30 Aug 2009 09:12:12 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

I will repeat...............the image is not "in the cell".

I got that.

Still, Excel does allow one to copy and paste a cell and it does get
carried when that happens. It only fails to get carried in a lookup
operation, which is part of the internal engine. Cut and paste is an
external construction engine function.

Any cut and paste of an image must be done manually or through VBA.

That is what I asked about.

John's lookuppics can be utilized.

Or they can be examined, and gleaned from.

And I REPEAT, that *I* CAN manually perform a cut and paste that DOES
carry it over, so I should be able to perform a scripted cut and paste
operation WITHOUT his code.

Even if my resultant product requires VB.

I wanted to perform it without VB scripting. Since a manual cut and
paste DOES carry it, there should be some way to get the spreadsheet
engine to do it, but I can also see why such a thing is an external
operation, and not an actual function of the spreadsheet engine.

As Gord said, the image isn't part of a cell, it kind of lays in a layer
above the sheet. I've done this kind of thing with a catalog that also
provides an estimate for equipment with pictures of them - down to the
scaling of the pictures. I didn't even have to graphics on another sheet, I
brought them in when required from disk files. It's kind of one of those
cases where you need to know the answer (name of graphic) before you can ask
the question. If you could put all of your graphics in one folder and name
them with some relation to your DVD titles, you could probably get started on
it in VB.

"AtTheEndofMyRope" wrote:

On Sun, 30 Aug 2009 09:12:12 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

I will repeat...............the image is not "in the cell".

I got that.

Still, Excel does allow one to copy and paste a cell and it does get
carried when that happens. It only fails to get carried in a lookup
operation, which is part of the internal engine. Cut and paste is an
external construction engine function.

Any cut and paste of an image must be done manually or through VBA.

That is what I asked about.

John's lookuppics can be utilized.

Or they can be examined, and gleaned from.

And I REPEAT, that *I* CAN manually perform a cut and paste that DOES
carry it over, so I should be able to perform a scripted cut and paste
operation WITHOUT his code.

Even if my resultant product requires VB.

I wanted to perform it without VB scripting. Since a manual cut and
paste DOES carry it, there should be some way to get the spreadsheet
engine to do it, but I can also see why such a thing is an external
operation, and not an actual function of the spreadsheet engine.