I have created a perpetual calendar spreadsheet. There is a list of holidays generated on a separate sheet. Within each cell of the calendar I search to see if it is a holiday using
=VLOOKUP(DATE(CalYear;CalMonth;C11);HolidayArray;2;0) This works fine. I display a blank if nothing is found. I would like a refinement as follows. If there are two holidays on the same date I would like the second one to appear on a separate line. My problem is that the table is not in sequence (it can't be since many holidays move from year-to-year) and I can only search for the first match. I need a way to have the second search begin after the location found for the first search. Any idea of how I can do this? It seems that I must dynamically change the addresses in the formula based on the first search. Instead of using the named HolidayArray I need to use aaa:bbb where aaa is a formula that will generate the beginning start cell. Can I concatenate a formula within an address? -- Dennis Marks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
