+ Reply to Thread
Results 1 to 2 of 2

Make Images Appear from a "YES" in a cell, using formulas?

  1. #1
    Registered User
    Join Date
    01-08-2021
    Location
    Northampton, England
    MS-Off Ver
    Office 365
    Posts
    1

    Make Images Appear from a "YES" in a cell, using formulas?

    Hi Guys,

    I am currently working on a checklist-style document which has images, and i was wondering if there is a way I can make an image from another sheet appear when I enter "YES" into another adjacent box?

    I can index/match, and vlookup images, but this doesn't work for a "YES" "NO" formula.


    Apologies for lack of example, it's hard to show in an example.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Make Images Appear from a "YES" in a cell, using formulas?

    Hard to answer if we cannot see what you have done.

    One guess:

    =IF(a1="YES",vlookup_that_works,"")

    maybe... but no idea without a sample sheet (not your real one - not interested in it).
    Glenn



+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] If cell equals "CR" then make cell to left negative and delete "CR".......
    By pasqualebaldi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2016, 07:51 PM
  3. Replies: 1
    Last Post: 07-04-2013, 07:43 PM
  4. Replies: 4
    Last Post: 05-30-2013, 10:36 PM
  5. Multiple Ifs = "W" to make cell = "W"
    By rbpd5015 in forum Excel General
    Replies: 5
    Last Post: 09-17-2010, 05:31 PM
  6. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM
  7. Replies: 6
    Last Post: 01-08-2006, 06:20 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1