Using Named Range in Formula

[Ada01]

I have created a named range using the folloing formula. I want to use it to multiply against a formula, it gives me a #VALUE! error. Is it possible to multiply with this kind of named range?

Formula
OFFSET(INDEX(Current!$A$1:$P6,SUMPRODUCT((Current!$A$1:$P6=600247)*ROW(Current!$A$1:$P$6)),SUMPRODUCT((Current!$A$1:$P$6=600247)*COLUMN(Current!$A$1:$P$6))),4,0,1,1)

Thanks

[NBVC]

You need to put an = sign in front of the Offset function in the ABC named range.

Once you fix it, you get a numeric result.