Index, Match for highest value

In the attached workbook, I'm attempting to post the latest work order detail info to a master listing of equipment.

1) I need to show the latest PM service date.
2) I need to show the latest "other" repair type service date ( which could be GM, RE, CD, or WY type). I just need the latest date for any of those types.
3) Finally, I need the latest Meter reading, regardless of type.

In my "Master" sheet, so far I've only accomplished finding the first work service date and the first meter reading listed for a piece of equipment. I don't know how to go from there.

Note: Some equipment will not have any work orders originally, and some equipment may have a service date but no meter reading because the equipment has no meter to read.

I've color-coded the columns I'm using as references in my calculations in the attachment.

See attached... check if that is what you need.

Are we basing this data on the X's being placed in the PM, etc... columns...

we can get rid of the #N/A errors later if everything else is okay.

Actually, I think the formula for the "Repair" column was incorrect... see attached revision....

I also cleaned up the #N/A errors while I was at it....

See my last post... I noted the error in the formula and gave a revised one....

From PM:

You me helped this morning with the above post. I thought it was solved, but, after adding some new detail for work order activity, I ran into a situation that is still giving me a problem.

Anyway, for Unit 7913 (in the file I sent you), I added a new work order for PM type. When I went back & looked at the Master, the "Last Repair Date" was also updated with that same "Latest PM Date". I did make sure that the version of the file I was using was the second zip file you sent me.

I'm too new to some of the functions you used to truly understand how to solve this myself. Can you help?

I adjusted the formula again... hope this is good now. See Attached.