| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
| changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
| changing relative to absolute | Excel Discussion (Misc queries) | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Worksheet Functions | |||
Linear Mode
