VLOOKUP For Pics

[DanielWalters6]

Is it possible to look up the value in a cell, and depending on that display
a small graphic from a table elsewhere in the spreadsheet.

At the moment, I have a small "system" which when a user picks a value from
a combo box, it is then put into a cell, then a cell that is located next to
the drop down displays a description of the product. It does this by looking
up the value that's stored in the cell, within a VLOOKUP statement.

Is it possible to do this with photographs - could I include a small
photograph of the product?

TIA For any help
Dan Walters

 

[CyberTaz]

There is no feature in Excel that will do something like this - images
aren't stored in cells, so they can't be "looked up" the way prices &
descriptions can. The one possible exception might involve a HYPERLINK fx,
but I've never used it for anything automated in the way you describe. I'd
be far more likely to use an actual database app for something like this.

I would think it could be implemented with VBA, but it would probably be
rather complex & intense - I'll leave that for someone who knows of what
they speak

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[DanielWalters6]

Thankyou for your help.

I have found a VBA version that works well.

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

Thankyou for your help!