Well, I found a way but I don't quite understand it. =INDEX(HolidayArray;SMALL(IF(Holidays.A3:A53=DATE($C$1;$B$1;C11);ROW(Holidays.A3:A53)-ROW(Holidays.A3)+1;ROW(Holidays.A53)+1);xx);2)
Where xx is the occurance number. "Dennis Marks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I have a table of dates and descriptions in Calc. It is in description >sequence and dates may be duplicated. I have no trouble searching the table >for the first matching date. I would like to find a way to do a second >search starting one cell down for a second matching date. I can find the >first cell with "match" and then using "offset" obtain the first cell to >search. I just can't find a way to use this information in a "vlookup" >formula. How do I dynamically create a range for the formula? >(startcell:z99 where startcell is a sub formula) > > Or is there a better way to do it? Please give example rather than just > telling me what formula to use. > > Thank you. > > -- > Dennis Marks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
