On Sunday 23 April 2006 22:16, Bob Long wrote: > > 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.
That solved the problem. Thanks! -- 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]
