Changing part of formula/leaving other parts intact

[JaysonOz]

Hello

I need to drag this formula down several cells however when I do itchanges the values by 1.

=VLOOKUP(A25,$A1:$I20,5,FALSE)

How do I keep the formula “$A1:I20,5,FALSE”intact but change A25 to be A26, A27, A28, etc.,?

Thank you.

 

[JugglerJAF]

You need to make the lookup area completely absolute by putting $ in front of both the column letter and row number like this:

=VLOOKUP(A25,$A$1:$I$20,5,FALSE)

 

[JaysonOz]

Thank you!