Maybe you could do something like JE McGimpsey does at:
http://www.mcgimpsey.com/excel/lookuppics.html
> I want to use something similar to the vlookup function to input a product
> code, and a BMP picture automatically is placed into excel and is
> automatically sized

Signature
Dave Peterson
Gord Dibben - 30 Aug 2007 16:17 GMT
In addition to Dave's suggestion........
As written John's code allows for only one picture to be displayed.
Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.
Alows for more than one picture to be displayed.
http://www.contextures.on.ca/excelfiles.html#DataVal
DV0049 - ClipArt Selection
Gord Dibben MS Excel MVP
>Maybe you could do something like JE McGimpsey does at:
>http://www.mcgimpsey.com/excel/lookuppics.html
>
>> I want to use something similar to the vlookup function to input a product
>> code, and a BMP picture automatically is placed into excel and is
>> automatically sized