VLOOKUP and LARGE functions

  • Thread starter Thread starter Efficient
  • Start date Start date
E

Efficient

Problem: I need a formula to check a database without sorting it an
produce the result in a cell. For Example:

..........A................B........
....Customer...Last Date
1....Acme
2
3
4
5
6....Acme..........12/11/01
7....Acme..........08/01/03
8....Acme..........05/04/03
9....Acme..........11/30/03
10..Acme..........01/21/02
11..Acme..........02/16/00

In Cell B1 I need the date of the last transaction for Acme. Visually
we know it's 11/30/03. But if when I type the following formula:
=vlookup("ACME",A6:B11,2,3)
it produces a date of 02/16/00.

This is the most simplistic example of my complex database, but withou
sorting my database by customer and date, how can I get the correc
result?

There doesn't seem to be a compound formula using the VLOOKUP and LARG
functions that will work.

Can anybody offer any suggestions

Attachment filename: last date.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47286
 
=MAX(IF(A6:A11=A2,B6:B11))

which must be confirmed with control+shift+enter instead of just with enter.

A2 houses the condition "Acme", A6:A11 customers, and B6:B11 dates.
 
Back
Top