ExcelBanter - Absolute Reference is changing

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Absolute Reference is changing (https://www.excelbanter.com/excel-worksheet-functions/185147-absolute-reference-changing.html)

Kenton

Absolute Reference is changing

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

Absolute Reference is changing

Hi,

to overcome that use indirect

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

Mike

"Kenton" wrote:

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)

Kenton

Absolute Reference is changing

Perfect. Thanks so much.

"Mike H" wrote:

Hi,

to overcome that use indirect

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

Mike

"Kenton" wrote:

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)

All times are GMT +1. The time now is 08:33 PM.