I have OOo 1.1.3 on Fedora Core 2 In Calc I have this formula in M3
=LOOKUP(K3;'Ship Formula'.E1:E9;'Ship Formula'.F1:F9)*L3 I want to drag it down about 1100 rows so that I get: =LOOKUP(K4;'Ship Formula'.E1:E9;'Ship Formula'.F1:F9)*L4 =LOOKUP(K5;'Ship Formula'.E1:E9;'Ship Formula'.F1:F9)*L5 =LOOKUP(K6;'Ship Formula'.E1:E9;'Ship Formula'.F1:F9)*L6 etc. But when I do that I get: =LOOKUP(K4;'Ship Formula'.E1:E9;'Ship Formula'.F1:F9)*L4 =LOOKUP(K5;'Ship Formula'.E2:E10;'Ship Formula'.F2:F10)*L5 =LOOKUP(K6;'Ship Formula'.E3:E11;'Ship Formula'.F3:F11)*L6 I read some where on the OOo site or in an e-mail from this list to do something like this: =LOOKUP(K3;'Ship Formula'.$E1:$E9;'Ship Formula'.$F1:$F9)*L3 Doing this just screws up my formula and results. Is there a way to accomplish what I want without editing every cell one at a time? When I have time I am going to up grade from FC2 to FC5 what version of OOo ships with FC5 and will the newer release of OOo help me with this issue? -- Jack Gates "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." "Minds are like parachutes, they only work when they are open." http://www.jlgates.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
