CF_RELATIVE
The CF_RELATIVE function can be used in a template to return a cell value with relative row and column references.
Enter the formula =CF_RELATIVE(<number of rows>,<number of columns>)
The following parameters need to be defined:
- Number of rows (up or down) the value should be fetched. Define the value with a minus if it should be in a row above.
- Number of columns (left or right) the value should be fetched. Define the value with minus if it should be in a column to the left.
Example
=CF_RELATIVE(1,2) will return the cell 1 row down and two columns to the right.
=CF_RELATIVE(-1,0) will return the cell 1 row above.
Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.