Find Last entry for Col in Multi column array using cell from another array.

[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

 

[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

PS I AM Sorry for the ERROR, The last Entry in my Example should be
9.00 not 4.90.