=INDEX(=BLP("NESN VX
Equity";"BEST_BRK_PERIOD_OVERRIDE=:1FY,BEST_EPS"); 0;2);)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nader" wrote in message
...
Sorry I totaly forgot to post the formula, here it is :

=BLP("NESN VX Equity";"BEST_BRK_PERIOD_OVERRIDE=:1FY,BEST_EPS"); 0;2)

Once I enter this formula in a cell, it becomes an array, like that :

{=BLP("NESN VX Equity";"BEST_BRK_PERIOD_OVERRIDE=:1FY,BEST_EPS"); 0;2)}

And it returns two values next to each other (eg. A1 and B1).

What I would like is only the second cell (B1) and not both ?

I've tried the worksheet function INDEX but they are still two cells which
are used in my sheet and I only want one.

Thanks !

PS : Nice proverb

"Dave F" wrote in message
...
Post your formula.
--
Brevity is the soul of wit.


"Nader" wrote:

Hello,

I've got an array formulas wich returns two values. Is it possible to
only
select one of the value ?

Thanks in advance.

Nader