+ Reply to Thread
Results 1 to 1 of 1

Creating a complex formula using 2010

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    41

    Creating a complex formula using 2010

    Here was the original formula:

    =IFERROR(INDEX(tblEvents,SMALL(IF(Dates=F$14,ROW(Dates)),ROW(1:1))-TableRowStart,4),"")

    I created a 2013 calendar, each sheet is one month, my front sheet are a list of activities that references dates throughout the year. I originally got the above from an ms office template for event planning. Although the template did what I wanted it was very limited so I created my own.

    What I need:

    I need a formula that when I am on the January 2013 sheet on Jan first, it will pull an array from tblevents (my date and events for that date table) and the cell will show the activity on the calendar (Happy New Year). Now I need a formula the can reference multiple activities on one day and on days with no activities it is left blank. Now the above formula does that but will not show the activity in the cell. if I use the created template as is its works, however if you double click on the cell in the calendar the activity disappears and will not return. I posted screenshot to google docs with formulas to assist.


    Vlookup works but does not leave cells blank with out N/A if it has nothing to reference and will not do multiple activities on one day

    This will take you to a google doc to show images:

    https://docs.google.com/document/d/1...it?usp=sharing
    Last edited by airedale360; 06-04-2013 at 11:02 AM. Reason: need an answer fast

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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