+ Reply to Thread
Results 1 to 2 of 2

If Statement using the selection from a drop down list in another workbook

Hybrid View

  1. 08-07-2014, 01:52 PM #1
    akirol
    akirol is offline
    Registered User
    Join Date
    08-07-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    1

    If Statement using the selection from a drop down list in another workbook

    I am setting up a schedule for a camp, each day there can are a many activity and I am using a drop down list for those choices (chart 1).

    I then linked them into each camp group using (=) (Chart 2).

    I now need to make another schedule for each of the activity exp “Ropes, GaGa Bal, V Softball. “ My issue is with the last chart, I need to populate the name of the camp group "Yale" only if that activity was selected. I tried an If statement. =IF([Andrea.xlsx]Red!$X$2:$X$29="ropes",[Andrea.xlsx]Red!$X$1,"") and as you can tell from Chart 2 “ropes” was selected but I am still getting a false.

    Chart 1
    Red
    START END 2B - Yale
    9:00 AM 9:15 AM
    9:15 AM 9:30 AM
    9:30 AM 9:45 AM Ropes
    9:45 AM 10:00 AM Ropes
    10:00 AM 10:15 AM Change
    10:15 AM 10:30 AM Swim C
    10:30 AM 10:45 AM Swim C
    10:45 AM 11:00 AM Change
    11:00 AM 11:15 AM GaGa BallCourt-2
    11:15 AM 11:30 AM GaGa BallCourt-2







    Chart 2

    2B - Yale Red 2B - Yale Yellow
    9:30 AM 9:45 AM Ropes Rock Wall & Giant Swing
    9:45 AM 10:00 AM Ropes Rock Wall & Giant Swing
    10:00 AM 10:15 AM Change Change
    10:15 AM 10:30 AM Swim C Swim C
    10:30 AM 10:45 AM Swim C Swim C
    10:45 AM 11:00 AM Change Change
    11:00 AM 11:15 AM GaGa BallCourt-2 Rope
    11:15 AM 11:30 AM GaGa BallCourt-2 Rope



    (Chart 3)
    Ropes

    START END RED Yellow
    9:30 AM 9:45 AM
    9:45 AM 10:00 AM
    10:00 AM 10:15 AM
    10:15 AM 10:30 AM
    10:30 AM 10:45 AM
    10:45 AM 11:00 AM
    Reply With QuoteRegister To Reply
  2. 08-07-2014, 01:54 PM #2
    Speshul
    Speshul is offline
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: If Statement using the selection from a drop down list in another workbook

    First thought is there might be unwanted spaces in the data you are looking at,

    Try =IF(TRIM([Andrea.xlsx]Red!$X$2:$X$29)="ropes",[Andrea.xlsx]Red!$X$1,"")

    If you could upload a copy of the spreadsheet for us to look at, it might be easier to see what the problem is. Click Go Advanced and then select the Paperclip to upload a (desensitized) sample sheet


    Edit: oh, i didn't notice you are looking at a range. Unless it is an array entered formula, an IF function will only look at X2, that is why it is coming back false.

    enter the below using Control+Shift+Enter (you will see {}'s surrounding the formula, indicating it is an array formula)
    =IF(SUM(--([Andrea.xlsx]Red!$X$2:$X$29="Ropes"))>=1,[Andrea.xlsx]Red!$X$1,"")
    Last edited by Speshul; 08-07-2014 at 02:00 PM.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make same selection for multiple drop down list and clear all for all dropdown list
    By salomip13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2014, 01:34 PM
  2. [SOLVED] Range in one drop down list depended on the selection in another drop down list
    By masben in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2013, 10:36 AM
  3. Autolock Cells from a Drop Down List Selection and a Calendar Selection
    By John Anderson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 10:54 AM
  4. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  5. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1