Value of a cell within a named range ?

[BBHRVS]

Hi;

I don't know how to get with a formula the value of a certain cell within a named range.

Basically I get the information of the position of the cell within the named range : e.g. this is the 18th in the first column of the range "DataAcc"

With VB, no issue :
Range("DataAcc").cells(18,1).value

But with a formula ?
I tried DataAcc(18,1), but this does not work

I am sure there is a solution ?
Thank you in advance.

 

[njimack]

Try =OFFSET(DataAcc,18,0,1,1)

 

[Dave Patton]

Did you try

=INDEX(DataAcc,18)

 

[BBHRVS]

Thank you very much. It works !