On Tue, 20 Dec 2005 00:00:45 -0500, Anthony Chilco wrote: >Hi Andrew, Eugenio, >As far as I know, OOo reads only the disk file when you use links to an Hello Andrew and Anthony!
Thank you for your help. The part of using Index and Match is solved. Now I have another problem and have no idea why this happens. If I have a cell B2 with this: =INDEX(Link.$F$2:$F$65536;MATCH(B9;Link.$D$2:$D$65536;0)) I get a number in currency format. In another cell C2 I have a number and in a third cell D2 a formula multlying the first two: =B2*C2 And this cell (D2) is always "empty". If in cell B2 I type a number in cell D2 appears the correct result. Am I doing something wrong when I try to use the formula in B2? Thank you, --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
