Vlookup based on 2 criteria

Ok, that was easy for you guys but.....

I have now another problem totally related to this matter.

I have 3 columns of data, NAME, DATE,TEXT

NAME Date Text
Carlos 1/1/4 Hello
Carlos 2/1/4 Good
Carlos 5/6/4 Mountain
Carlos 6/6/4 CORRECT1
Peter 5/5/4 Friday
Peter 20/6/4 CORRECT2

date is in format dd/mm/yy

The forula that I need to use is

Look for CARLOS in the database, and retrieve TEXT when NAME is CARLOS
and DATE is the LATEST (for carlos of course).

In this example if I look for Carlos the data I want is CORRECT1
If I look for Peter the data I want should be CORRECT2

The formula I tried was

=index(Names,MATCH(1,(Names=Carlos)*(Dates=Max(Dat es)),0)

I retrieve 0 all the time.

I think it is because it doesn't match the latest date for carlos. I
can't make it work.

Any ideas will be very much appreciated.

Thanks and regards,
Carlos.


---
Message posted from http://www.ExcelForum.com/