Absolute Reference is changing

[Kenton]

I have the following equation (below) in my spreadsheet and everytime I add a
line the 'Key' page (which is row 14) the absolute cell being referenced
($B$15) keeps changing to $B$16 and I don't understand why that is. Any help
would be much appreciated.

=VLOOKUP(KEY!$B$15,A1:B75,2)

 

[Mike H]

Hi,

to overcome that use indirect

=VLOOKUP(INDIRECT("Key!B15"),A1:B75,2)

Mike

 

[Kenton]

Perfect. Thanks so much.

Hi,

to overcome that use indirect

=VLOOKUP(INDIRECT("Key!B15"),A1:B75,2)

Mike