jondallimore
Board Regular
- Joined
- Apr 26, 2012
- Messages
- 136
Hello,
This is probably something really obvious but Ive been bashing my head against a brick wall for a while and its starting to get squishy.
I am referring to a cell, A1, in formulae in a set of cells that go from A1 to B4.
When I copy these cells, the references to A1 become references to A7.
I would like these refereces to refer to A2 instead - How do I do that, and can it be done with little sleep and a squishy head?
Thanks
Also... I am using a VLOOKUP formula which I always want to refer to the top right cell in the range of 8 cells I am using, even when the formula is copied to another range of cells.... Any way to do that?
Thanks again.
This is probably something really obvious but Ive been bashing my head against a brick wall for a while and its starting to get squishy.
I am referring to a cell, A1, in formulae in a set of cells that go from A1 to B4.
When I copy these cells, the references to A1 become references to A7.
I would like these refereces to refer to A2 instead - How do I do that, and can it be done with little sleep and a squishy head?
Thanks
Also... I am using a VLOOKUP formula which I always want to refer to the top right cell in the range of 8 cells I am using, even when the formula is copied to another range of cells.... Any way to do that?
Thanks again.
Last edited: