Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you use a vlookup to bring in a picture?
I have a form template where in the first column I choose an option from a
drop down box. Each of these options has a picture. Is it possible to use eg a vlookup function to bring in the correct picture based on what I choose in the drop down box, or would I have to copy and paste these in manually? Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you use a vlookup to bring in a picture?
J.E. McGimpsey has a routine that hides/unhides pictures based on the value of a
cell. http://www.mcgimpsey.com/excel/lookuppics.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Marlsnz wrote: I have a form template where in the first column I choose an option from a drop down box. Each of these options has a picture. Is it possible to use eg a vlookup function to bring in the correct picture based on what I choose in the drop down box, or would I have to copy and paste these in manually? Cheers -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I bring forward formats with Vlookup? | Excel Worksheet Functions | |||
Insert Picture from dropdown selection | New Users to Excel | |||
insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
vlookup and picture | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) |