Changing part of formula/leaving other parts intact

JaysonOz

New Member
Joined
Oct 9, 2018
Messages
2
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

Active Member
Joined
Feb 17, 2002
Messages
264
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)
 

Forum statistics

Threads
1,078,364
Messages
5,339,760
Members
399,321
Latest member
ladeko

Some videos you may like

This Week's Hot Topics

Top