I want to fill/copy a formula within a specific range but each time I try to
fill or sopy it changes the range it is supposed to looking in so I am
getting errors.

For example,

Row 1 - =LOOKUP(J2,Sheet1!A2:A153,Sheet1!B2:B153)
Row 2 - =LOOKUP(J3,Sheet1!A2:A153,Sheet1!B2:B153)

But, if I just copy or fill I am getting the second row showing up as:
=LOOKUP(J3,Sheet1!A3:A154,Sheet1!B3:B154) instead of as Row 2 above. I do
not want to type the formula 500 times.

Is there a solution?