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]
