last instance

S

sal

Hi I have a worksheet with auto maintenance info. Column "J" has info
like oil change, air filter etc column "A" has the date I did it and
column "B" has the odometer reading when done.
What I would like to do is get ex. the last instance of oil change in
column "J" and copy the date and odometer reading to a cell of other
worksheet.
Thanks
 
A

Aladin Akyurek

On Sheet2:

In E2 enter: oil change

In F2 enter & copy across to G2:

=LOOKUP(2,1/(Sheet1!$J$2:$J$100=$E2),A$2:A$100)
 
Top