B
bob
Hi,
My problem is with an arrray lookup. I am new to this and not sure how
my example will show up on the page - but hope my explanation is
clear.
i.e. A B C D
Date Symbol Qty Price
010510 F 1000 5.00
010510 LSI 500 4.50
031510 F 500 9.00
111010 LSI 1000 4.90
Lookup cell T4 displays a symbol (F), H1 displays a date (01/01/2010),
(Date Range and Symbol with which to find Price).
I tried =LARGE(IF($B6:$B754=T4,IF($A$16:$A$754>=$H1,$D16$K$754),1)
using { } on either end. The formula works in most instances, but
gives wrong result randomly. I tried using MAX, Sum(IF), INDEX, but
all had problems. I need only the Price from (Largest or Last Date)
entered for a company that comes from another array which in this case
is (T4) with result of "F".
the Last or largest or Max date, for a given Symbol. The example
should produce 4.90 as the last date F was entered.
Thanks in advance for help received.
Bob
My problem is with an arrray lookup. I am new to this and not sure how
my example will show up on the page - but hope my explanation is
clear.
i.e. A B C D
Date Symbol Qty Price
010510 F 1000 5.00
010510 LSI 500 4.50
031510 F 500 9.00
111010 LSI 1000 4.90
Lookup cell T4 displays a symbol (F), H1 displays a date (01/01/2010),
(Date Range and Symbol with which to find Price).
I tried =LARGE(IF($B6:$B754=T4,IF($A$16:$A$754>=$H1,$D16$K$754),1)
using { } on either end. The formula works in most instances, but
gives wrong result randomly. I tried using MAX, Sum(IF), INDEX, but
all had problems. I need only the Price from (Largest or Last Date)
entered for a company that comes from another array which in this case
is (T4) with result of "F".
the Last or largest or Max date, for a given Symbol. The example
should produce 4.90 as the last date F was entered.
Thanks in advance for help received.
Bob