On Mon, 26 Dec 2005 18:18:32 +0000, Eugénio Varejao wrote: >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.
Hi! I found the problem. The formula =INDEX(Link.$F$2:$F$65536;MATCH(B9;Link.$D$2:$D$65536;0)) does not retrieve a number but a string, the data come from an 123 file. In 123 it is a number but when pasted in Calc is a string. Now I need to found a way to conver almos 3000 cells from string to number!! Anyway, thank you for your time! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
