Absolute Reference is changing

  • Thread starter Thread starter Kenton
  • Start date Start date
K

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)
 
Hi,

to overcome that use indirect

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

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

absolute reference fill 1
Absolute Reference Changes 2
Absolute References and worksheets 0
Conditional Formatting with absolute references 3
return value from table 2
Why is my OFFSET function not working? 2
Conditional formatting offset reference 3
create reference formula that looks through all sheets for matchin 2

Back
Top