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