bertusavius
Board Regular
- Joined
- Feb 28, 2008
- Messages
- 82
I am familiar with the INDIRECT function in the sense that it creates a relation to an absolute cell position.
Is it also possible to create a relative relation?
i.e. Is it possible to let a funtion be dependent on a cellPOSITION that is x positions to the right or left of the function cell?
I'd like to be able to drag and drop cells around the sheet and still keep the funtions that relate to these cells untouched in the process, but I dislike the idea that all my functions relate to absolute cell postions because it basically locks the layout of my sheet.
Any help is much appreciated.
Is it also possible to create a relative relation?
i.e. Is it possible to let a funtion be dependent on a cellPOSITION that is x positions to the right or left of the function cell?
I'd like to be able to drag and drop cells around the sheet and still keep the funtions that relate to these cells untouched in the process, but I dislike the idea that all my functions relate to absolute cell postions because it basically locks the layout of my sheet.
Any help is much appreciated.