Tags: advice, corresponding, excel, insert, link, microsoft, msdn, picture, software, spreadsheet, stuck, vlookup, writing
Using VLookup to insert corresponding picture
Hello - I'm stuck with a spreadsheet I'm writing for work and could use
I have a Vlookup set up, and I'd like to link a graphic ( a JPG file I
used Snag-it to capture) to be inserted that corresponds to the
selection. I have 4 different scenarios that could exist.
How can I have the appriopiate picture inserted? WHat sort of function
would I use? Does this require a macro' Lastily, where is the easiest
place to store my jpgs for this application (in clip-art, another
work-sheet page, etc)'
ANy help is appreciated-
Message posted from http://www.ExcelForum.com/
Leave a comment...
- 1 Comments
- the best way to bring up a picture is to use a hyper link and store all
the jpegs in the same folder. there is a way to tell excel where to
look for them. a sample of your spreadsheet and the pictures would make
it eaiser to figure out.
Message posted from http://www.ExcelForum.com/#1; Fri, 23 May 2008 19:54:00 GMT