Hi There!
Hoping this is pretty simple, I just can't work it out, I know a plain vlookup isn't the answer, nor is using absolute $, I've tried indirect and another couple of options but to no success. The spreadsheet has more info, however for example purposes I have simplified it.
What I'm trying to do is always compare the current fortnight to previous on a summary sheet, which is feed to from a data sheet. This data sheet format cannot be changed as I don't create it, what happens is each fortnight rows are inserted at the top of the data sheet and that then becomes the current fortnight. The current fortnight values will always be B4 and previous fortnight will always be B8 regardless of how many cells are inserted.
Example Data Sheet
This is then pulled through to a summary sheet (simplified for this example), where I always need Current to reference B4 from the Data sheet and Previous to reference B8. I've included vlookup to show where it's referencing.
If only there was an absolute option that didn't allow for cells to change when rows were inserted... any help is greatly
Thanks in advance!
Hoping this is pretty simple, I just can't work it out, I know a plain vlookup isn't the answer, nor is using absolute $, I've tried indirect and another couple of options but to no success. The spreadsheet has more info, however for example purposes I have simplified it.
What I'm trying to do is always compare the current fortnight to previous on a summary sheet, which is feed to from a data sheet. This data sheet format cannot be changed as I don't create it, what happens is each fortnight rows are inserted at the top of the data sheet and that then becomes the current fortnight. The current fortnight values will always be B4 and previous fortnight will always be B8 regardless of how many cells are inserted.
Example Data Sheet
This is then pulled through to a summary sheet (simplified for this example), where I always need Current to reference B4 from the Data sheet and Previous to reference B8. I've included vlookup to show where it's referencing.
If only there was an absolute option that didn't allow for cells to change when rows were inserted... any help is greatly
Thanks in advance!