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