By the way the formula has to be an array formula {}.
"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]
