populating an excel calendar with excel source data
I have two spreadsheets in one workbook. One spreadsheet is a calendar in which I want to populate with each events from the second spreadsheet, the data source.
so far this formula works =IF(Calendar!$K$23='2009 (2)'!U3,INDEX('2009 (2)'!A3,MATCH('2009 (2)'!U:U,'2009 (2)'!A3,'2009 (2)'!U3))&" - "&'2009 (2)'!C3&" - "&'2009 (2)'!R3) but when i drag the formula through the range of the calendar date (which is 15 cells), i get false if data is not a match as in the example below. the (1) Is the date (2/1/2011)
1 10109 - Bradford - Deva & Assoc
This is not what I want,(though this is what I told excel to do), I would like to do is, if the data is not a match then skip the unmatches until you find the next match and populate the data with the correct date.
What am I missing???
Last edited by kmclean; February 10th, 2011 at 02:23 PM..