To find the last 9 in A1:A100:
Ctrl/shift/enter:
=MAX(ROW(1:100)*(A1:A100=9))
Then use this value (say it's in E1) as input to the Index: =INDEX(B:B,E1)
HTH
Bob Umlas
Excel MVP

"bradsmith37" wrote in message
...
i have 2 columns of data. the first is a box number from 1-15 the second
is
the time and date the part was weighed. i want to find the last time a
box
number was used, say 9, and have the corresponding date copied to another
cell.
thank you in advance for your help, BS.

8 4/25/2006 15:15
11 4/25/2006 15:16
9 4/25/2006 15:16
10 4/25/2006 15:17
15 4/25/2006 15:18
2 4/26/2006 7:15
9 4/26/2006 7:15
7 4/26/2006 7:16
5 4/26/2006 7:24
9 4/26/2006 7:24
14 4/26/2006 7:24
15 4/26/2006 7:26