"Jack Gates" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >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.
I think what you require may be: =LOOKUP(K3;'Ship Formula'.$E$1:$E$9;'Ship Formula'.$F$1:$F$9)*L3 (note the extra dollar signs that "freeze" both the column and row references. -- Bob Long --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
