Formula pattern not being recognized

[JOn]

Here is the equation
=LOOKUP(C10,ARRAY!B3:C128)
=LOOKUP(C11,ARRAY!B3:C128)
=LOOKUP(C12,ARRAY!B3:C128)

That is the pattern, we want to continue this patter down through a long
list. When we highlight the 3 entries and try to drag the formulas to
the other cells the pattern is all messed up. That is a pretty simple
pattern above you can tell the only thing that needs to change is the
first cell reference, but this is what outlook does.

=LOOKUP(C13,ARRAY!B6:C131)
=LOOKUP(C14,ARRAY!B6:C131)
=LOOKUP(C15,ARRAY!B6:C131)
=LOOKUP(C16,ARRAY!B9:C134)
=LOOKUP(C17,ARRAY!B9:C134)
=LOOKUP(C18,ARRAY!B9:C134)

Does anyone know how ot make it understand the pattern we are wanting?

Thanks
Jon

 

[Peo Sjoblom]

Try

=LOOKUP(C10,ARRAY!$B$3:$C$128)