Find function

[alamo]

How can i get the last values on next table :

DATE KM TYPE
16-06-2001 233.513 TIRE CHANGE
16-10-2001 281.634 VALVULINE CHANGE
09-03-2002 356.210 TIRE CHANGE
06-03-2003 515.783 VALVULINE CHANGE
29-08-2003 597.360 OIL ENGINE CHANGE
09-09-2003 602.500 TIRE CHANGE
28-11-2003 643.266 OIL ENGINE CHANGE
11-02-2004 681.003 TIRE CHANGE
04-03-2004 693.005 OIL ENGINE CHANGE
20-04-2004 717.489 TIRE CHANGE
26-05-2004 720.890 TIRE CHANGE
01-07-2004 732.628 OIL ENGINE CHANGE
24-07-2004 761.683 TIRE CHANGE
01-09-2004 781.207 OIL ENGINE CHANGE
01-09-2004 781.207 VALVULINE CHANGE
29-01-2005 840.225 TIRE CHANGE



DATE KM
THE LAST OIL CHANGE
THE LAST VALVULINE CHANGE
THE LAST TIRE CHANGE

 

[Domenic]

Assumptions:

A1:C17 contains your data

First row contains your headers/labels

E2: Oil Engine Change

E3: Valvuline Change

E4: Tire Change

Formula:

F2, copied down and over to the next column, Column G:

=LOOKUP(2,1/($C$2:$C$17=$E2),A$2:A$17)

Hope this helps!