Formula pattern not being recognized

  • Thread starter Thread starter JOn
  • Start date Start date
J

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
 
Back
Top