Jos,

Have a look at the Index function.

e.g. Index(Test,3) returns the cell in the 3rd row of a vertical range.

Robin Hammond
www.enhanceddatasystems.com

"Jos Vens" wrote in message
...
Hi,

can anyone tell me if it is possible to make a formula that gives an item
of
a named range which contains more than one cell?

eg. I have a named range called "Result" and I want to have the third
result
in a cell. It should be something like:

=Result.cells(3) but cells does not exist in Excel, only in VBA

Thanks
Jos Vens