Resolved >>> Max Index Lookup Returning Two Cells?

I have a formula I need to modify.

In column b I have a list of items by number, each one is unique
In column c I have a list of items by number. In this column a item may not be listed or listed 1000's of times.
In column d I have a list dates for each of the items listed in column c
In column e I have a list of prices for each of the items listed in in column c

The idea with the orginal formula was to look up the item and return the date

=MAX(INDEX(($C$2:$C$39999=B2)*(D$2:D$39999), 0))

Now I need to get it to return the most recent date from column d and the dollar amount right next to it from column e. How would I do that?

I trying to return the most recent date and price for a item.

I thought about breaking this into two formulas and having the second formula read the date that was returned from the above formula and the item number from column b and returning the value from e, but got stuck. I was thinking a lookup function with two criteria.

What did you have going in A1 and F1? A1 was were I was returning the most recent date for the item.

So assuming the result of your first formula is in A1 try

=LOOKUP(2,1/((C2:C39999=B2)*(D2:D39999=A1)),E2:E39999)

Thanks Forthe Help. I'll Try It.

I tried the sumproduct function. It didn't seem to work for every item at first. Then I reread it and seen that it was adding up identical records. I removed all the duplicates and it worked just fine. Thank you

I didn't try the other formula because I didn't understand the "(2,1/" uin there.

Thanks for the help.