+ Reply to Thread
Results 1 to 7 of 7

display a picture in a cell when the picture name is selected

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Bandaragama,Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    16

    Angry display a picture in a cell when the picture name is selected

    Hi

    I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula

    My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.

  2. #2
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: display a picture in a cell when the picture name is selected

    Hi... it may be helpful for you to post a workbook to clarify your question a bit. If it's sensitive data, or pictures that you cannot share, consider altering a subset of them - without knowing the structure of your data, where the drop down is, how the IF statement is called, and what the error is, it's difficult to assist you.

    The good people here are incredibly helpful, but the more info you can provide, the better.

    Thanks!

  3. #3
    Registered User
    Join Date
    12-13-2013
    Location
    Mount Pleasant, SC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: display a picture in a cell when the picture name is selected

    sorry for interrupting this post...but how do I submit a question? Thanks!

  4. #4
    Registered User
    Join Date
    01-14-2013
    Location
    Bandaragama,Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: display a picture in a cell when the picture name is selected

    Hi

    Thanks for your quick response

    I have attached a sample file where in the 'Main' chart when I select a picture from the drop down menu it will automatically display the relevant picture from the other sheet

    I have done this by using the IF function in the formula named as picture ( =IF(Main!$F$5="house",pics!$C$6,IF(Main!$F$5="box",pics!$C$7,pics!$C$8)) & it works perfectly

    what I need to know is whether the IF function can be replaced with a VLOOKUP

    Thanks
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-14-2013
    Location
    Bandaragama,Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: display a picture in a cell when the picture name is selected

    Hi
    First get registered with a UID & Password then you can submit a post. Its free

    Rgds

  6. #6
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,263

    Re: display a picture in a cell when the picture name is selected

    Not with VLOOKUP I guess, try this:

    =INDEX(pics!$C$6:$C$8,MATCH($F$5,pics!$B$6:$B$8,0))

    But you need to set up the table like in the file attach
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-14-2013
    Location
    Bandaragama,Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    16

    Red face Re: display a picture in a cell when the picture name is selected

    Thank you very much - it worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Display picture if a cell is between a certain value
    By milo1984 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2014, 10:30 AM
  2. Display selected picture value in a cell
    By pajc72 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2014, 05:36 AM
  3. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  4. [SOLVED] [How to] If width of selected picture is bigger than 25 cm, resize picture width to 25 cm
    By 1tane1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2013, 09:12 AM
  5. VBA for Picture insert at particular worksheet range. Picture name derived from cell.
    By Douglas2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2013, 01:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06350 seconds
  • Memory Usage 9,021KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1