Trying to obtain the maximum value of only certain rows

Hi all.... I have used Excel for many many years (and love it). I currently have a problem that I can't seem to solve efficiently.

Ok.. So I am creating a vehicle maintenance spreadsheet. I have one sheet that is a complete log of everything that I do with the vehicle, then another sheet that you plug in the current mileage and it tells you when your next oil change is due, tune up, etc. So here is the problem.

I am trying to reference my main log page and basically create a formula for each maintenance item that says something like this:

Do a lookup on the main log. Find all rows that list "1 - Oil Change" and of ONLY THOSE ROWS find the maximum mileage and use that in this field + 3000 miles.

I would create that for each maintenance item. I tried a

=VLOOKUP(AND("Oil Change",MAX(C1:C200).....

It didn't like that (and I didn't think it would - lol). Any ideas?

Yup this was exactly what the doctor ordered!!!! In my many many years using Excel this is one thing I never used (or really knew about!). Glad to have learned it!

Thanks so much for your help.