Hi There,

I have the following formulas:

Formula #1: {=MATCH(TRUE,$AD$8:AD1000>0,0)} (Array Formula) and the result in my worksheet is = 2 which is correct
Formula #2: =ADDRESS(2+MATCH(O3,$A$3:$A$1000,-1),30) and the result of this formula is = $AD$8 which is correct

if I try replacing the statement $AD$8 in Formula #1, with the complete Formula #2 as follows:

{=MATCH(TRUE,ADDRESS(2+MATCH(O3,$A$3:$A$1000,-1),30):AD1000>0,0)}

I get a #Value! error

Even if I replace the statement $AD$8 in Formula #1 with a simple formula such as ADDRESS(8,30) (result = $AD$8) as follows:

{=MATCH(TRUE,ADDRESS(8,30):AD10000>0,0)}

I get a Value error...

Thanks