VLOOKUP and pictures ?

dirty_cofi · May 6th, 2002, 04:07 AM

hey,

for a project i am going a order form in excell and i want it so if they select the product name in the drop down list that excel then will return a picture of that item via VLOOKUP.

The problem seams to be that pictures don't have a cell reference so VLOOKUP can't be used, so any ideas please.

Thanks

Chris Davison · May 6th, 2002, 05:29 AM

http://www.mrexcel.com/board/viewtop...c=1773&forum=2

this is nearly the same, maybe you can tailor it to suit your needs ?

dirty_cofi · May 6th, 2002, 07:59 AM

Thz i think i can get it to work now, i'll hav to brush up on my coding

later

May 6th, 2002, 05:29 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	http://www.mrexcel.com/board/viewtop...c=1773&forum=2 this is nearly the same, maybe you can tailor it to suit your needs ? __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 04:07 AM	#1
dirty_cofi New Member Join Date: May 2002 Posts: 13	hey, for a project i am going a order form in excell and i want it so if they select the product name in the drop down list that excel then will return a picture of that item via VLOOKUP. The problem seams to be that pictures don't have a cell reference so VLOOKUP can't be used, so any ideas please. Thanks

May 6th, 2002, 07:59 AM	#3
dirty_cofi New Member Join Date: May 2002 Posts: 13	Thz i think i can get it to work now, i'll hav to brush up on my coding later