Index Match Formula, can index be fixed?

I have an index match Formula that works great for the first row. But each row that I copy down, the references get all messed up. I need to have the match field change, but the remaining formula to remain. Is there a way to make certain references in an Excel formula fixed and others that will change when copied down to another row? I'll post the formula if this isn't enough to go off of. Thanks.

You need to use absolute references, rather than relative references, and you can achieve that by putting $ symbols before the references. For example, if you have:

=INDEX(A1:A100,MATCH(....

then that will change to:

=INDEX(A2:A101,MATCH(....
=INDEX(A3:A102,MATCH(....
=INDEX(A4:A103,MATCH(....

and so on when you copy it down. Instead, you should change it to:

=INDEX(A$1:A$100,MATCH(....

so that the 1 and 100 do not change when you copy it down. You could also change it to:

=INDEX($A$1:$A$100,MATCH(....

so that the A does not change if the formula is copied across.

You might also do the same to the range in the MATCH part of the formula.

Hope this helps.

Pete