Can IF function be combined with OFFSET, actually I need to set some condition and if it is true set OFFSET with some values and if condition is false set OFFSET with different values.
Here is my example that is not working:
IF(Sheet1!$A$1="EN";OFFSET(Sheet2!$Y$2;;;COUNTA(Sheet2!$Y:$Y)-1);OFFSET(Sheet3!$Y$2;;;COUNTA(Sheet3!$Y:$Y)-1))
I need resulting OFFSET for creating dorp-down list on Sheet1.
Here is my example that is not working:
IF(Sheet1!$A$1="EN";OFFSET(Sheet2!$Y$2;;;COUNTA(Sheet2!$Y:$Y)-1);OFFSET(Sheet3!$Y$2;;;COUNTA(Sheet3!$Y:$Y)-1))
I need resulting OFFSET for creating dorp-down list on Sheet1.