Tags: advice, corresponding, excel, insert, link, microsoft, msdn, picture, software, spreadsheet, stuck, vlookup, writing

Using VLookup to insert corresponding picture

On Microsoft » Microsoft Excel

1,037 words with 1 Comments; publish: Fri, 23 May 2008 19:53:00 GMT; (306109.38, « »)

Hello - I'm stuck with a spreadsheet I'm writing for work and could use

some advice.

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-

Thanks,

Tom

--

Message posted from http://www.ExcelForum.com/

All Comments

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.

      jason

      Message posted from http://www.ExcelForum.com/

      #1; Fri, 23 May 2008 19:54:00 GMT