@COORD(worksheet,col,row,cell_absolute)
constructs a cell address corresponding to worksheet, row,col,
cell_absolute: 1=$A:$A$1…….8=A:A1
e.g @COORD(1,5,3,1) Sheet 1, col 5, row 3, absolute
@@(@COORD(C1;D1;E4;8)) returns the value in cell A:A4 (C1 contains 1; D1 contains 1; and E4 contains 4).
thanks for prompt help
I think they are:
COORD() ==> ADDRESS(Row; Column; Abs; A1; “Sheet”)
@@ ==> INDIRECT(Ref; A1)
with the function wizard you can see the parameters.