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