On Mon, 2005-02-21 at 17:17, James Elliott wrote: [snip] > But ... how do I find the DATE which is in the column to the left of my > search matrix?
An unacceptable solution might be to rearrange the columns, or have a hidden column that equals the date column or: Use a combination of index and match. I confess to not having tested this on a large spreadsheet in Calc but in Excel it slowed the spreadsheet considerably. E.g. =INDEX($Sheet2.$A$2:$A$10;MATCH(A2;Sheet2.B2:B10;0)) Thanks, Ian Laurenson --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
