Hi,

It doesn't rely on that and will work with either/both columns
sorted/unsorted. Have you tried it?

Mike

"Lars-Åke Aspelin" wrote:

This formula relies on that column B is sorted with increasing dates
Of that we know nothing I think.

Lars-Åke


On Thu, 24 Jul 2008 00:38:00 -0700, Mike H
wrote:

Try this

=LOOKUP(2,1/(A1:A20=C1),B1:B20)

Where C1 is the item you are looking up.

Mike

"why-J" wrote:

I have a very simple two column list. Col-A is "Products" col-B is "Date
Purchase". Col-A is un-sorted and various products are repeated several
times. I want a lookup formula that would tell me the most recent date when a
particular product was purchased.

If col-A was sorted ascending, I could use
=LOOKUP(1E+100,INDEX(A2:B8,MATCH(A12,A2:A8,1),0)). Can someone please help.