Newbie question, I have a formula that I want to fill down a column =INDEX(AA286:AA541,MATCH(B3,Z285:Z541,0)) but when I fill down the column it keeps changing AA and Z starting numbers is there any way to keep this from happening? Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula Fill Question
- Thread starter MRJ63
- Start date
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,345
- Office Version
- 365
- Platform
- MacOS
use $ ti fix the row and column
=INDEX($AA$286:$AA$541,MATCH(B3,$Z$285:$Z$541,0))
its called relative and absolute addressing - if you wanted to lookup any training - websites - youtube sites to understand fully
the $ fixed that references
so
$A1
will not change the A - if fill down you get A2,A3,A4
But copying across you get A1,A1,A1
if you then fix the row only
A$1
will not change the 1 - if fill down you get A1,A1,A41
But copying across you get B1,C1,D1
fix both row and column $A$1
then no matter if copied down or across - will be A1 in all cells
=INDEX($AA$286:$AA$541,MATCH(B3,$Z$285:$Z$541,0))
its called relative and absolute addressing - if you wanted to lookup any training - websites - youtube sites to understand fully
the $ fixed that references
so
$A1
will not change the A - if fill down you get A2,A3,A4
But copying across you get A1,A1,A1
if you then fix the row only
A$1
will not change the 1 - if fill down you get A1,A1,A41
But copying across you get B1,C1,D1
fix both row and column $A$1
then no matter if copied down or across - will be A1 in all cells
Upvote
0
That's what I needed, Thank You!
Upvote
0
Similar threads
- Question
