You want another function that will return the value 20?

it should be doable.

Without knowing mo

Public Function Rate1(Ben)
v = DateRate(ben)
Rate1 = v(lbound(v,1), lbound(v,2)+1)
End Function

--
Regards,
Tom Ogilvy


"guedj54" wrote in message
...
I have an array-formula called DateRate() that return a list of dates and
their rates for example DateRate(Ben) will return:
10/02/2006 20
15/02/2006 34
17/02/2006 56
03/10/2006 40

I will need to have a function that is not an array formula and that will
return only the rate of the first date. For example in this case 20.

Is it doable?

Many thanks
Paul