The following issue was due (mainly) to formula parameter settings, as explained by the first answer. It is left like that to help if others get stuck similarly.
I need to identify the cells containing the occurrences of a value (“TRUE”) in a column, say E.
With a simple MATCH function I find the first one. With that I calculate the row number of the cell with the first occurrence of “TRUE” in another cell, say M15.
Now I would like to go on searching on the rest of the E column after the cell of the first MATCH.
I try to use a formula like
=MATCH(“TRUE”, ADDRESS(M15, 5, 4, 1):E$100,0)
but I get the Err:502.
I tried to use INDIRECT and other functions (OFFSET, etc.) but I cannot find a way.
What am I doing wrong?