formula keeps changing

[Sabiaeric]

=INDEX(Enumbers!C2:C60,MATCH('final data'!B2,Enumbers!B2:B60,0))

Question:
the above formula is giving me some issues. i have a work around but it is long.

the formula is correct BUT i need to move it to several cells and the formatting of the formula must remain the same.

Enumbers!C2:C60 and Enumbers!B2:B60, can not change.

final data'!B2 is the only point that needs to change.


copy and paste will fill each cell i need but till move the formula to adjust for the new position .
is there a way to stop this from happening?

i can manually go in and fix the issue, but if there is and easier way , i would love to know.



example
=INDEX(Enumbers!C2:C60,MATCH('final data'!B2,Enumbers!B2:B60,0)) --- cell A2
=INDEX(Enumbers!C3:C61,MATCH('final data'!B3,Enumbers!B3:B61,0)) --- Cell B2
=INDEX(Enumbers!C4:C62,MATCH('final data'!B4,Enumbers!B4:B62,0)) --- Cell c2

 

[jproffer]

Instead of...C2:C60, use...$C$2:$C$60

same for the other one. Or you can mix and match as you like. A "$" in front of either the column reference or the row reference will 'lock' it. So you could use:

C2 to allow both to "move with cells"

$C2 to allow only the row to move

C$2 to allow only the column to move

 

[Sabiaeric]

that did it ,

thanks for the help!

 

[jproffer]

No problem at all. Glad to help. Thanks for the feedback.