View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kenton Kenton is offline
external usenet poster
 
Posts: 9
Default 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)