Hi Dennis, You can do that using the match function in an indirect address. For the first holiday, you use the match to create the address for the holiday. For the second, you use the first match to set the start row for a vlookup. If you want to try for three, then the second needs to be a match as well and that function gets used in the third search. tc
> 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
