# Find function

1. ## Find function

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

--
alamo

2. ## Re: Find function

Assumptions:

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!

In article <alamo.1vgbzn@news.excelbanter.com>,
alamo <alamo.1vgbzn@news.excelbanter.com> wrote:

> 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1