Results 1 to 23 of 23

If condition to show list based upon another cell value

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2005
    Location
    United States
    MS-Off Ver
    Office 2010 - Win
    Posts
    38

    If condition to show list based upon another cell value

    Hello everyone. I am trying to add a list to a cell using data validation. What I am trying to accomplish is basically: if cell A1 equals 1 then show list, otherwise show blank (or no list will be shown), however I cannot get it to work that simply. What I have tried is adding a data validation using custom and then including the following formula: =IF($A$1="1",List,""), however this does not work. If this is possible, could someone please help me with the proper method of doing this?
    Last edited by tm1274; 07-07-2021 at 08:33 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine and show two list in data validation with if condition
    By arunvijilan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2020, 06:07 AM
  2. How to show Images in a Cell based on a condition?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-15-2014, 08:00 AM
  3. [SOLVED] formula required to list cell values based on condition
    By kiranpat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 04:54 AM
  4. Show/Hide a sepcific column based on a condition in a cell
    By uakhan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 05:50 AM
  5. Code How to show alert messages with the IF condition based on other cell value
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2013, 09:51 PM
  6. [SOLVED] Show a unique list of items based on Cell value
    By gorgon777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-10-2013, 12:18 PM
  7. Replies: 4
    Last Post: 05-25-2012, 04:16 AM

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