Multiple column lookup using index match

Hi All,

Im looking for an index match formula for multiple columns. this is what i exactly need.

For the ID 66195 in the attached file, i need the time which is against the max number in column E for each code (PBRK1, UBRK2, PBRK3).

Attached is the file related.

Thanks,
Dawson

Hi i have created the formulas for you in row 15 assuming you data set is not dynamic,
let me know if otherwise

Thank you for the response, however this would not help as the IDs are multiple but in the sheet provided only one ID, consider there are multiple ids with the same codes and i need to get the time against the max value for each ID

perhaphs if you post the sheet or tell me a little more about the data set i can help. is the data static? are there always the same amount of codes and same amount of ID's?

Here u go, attached the sheet, now in this sheet against each id in column H, i need the time under each code for each id which has the max value in Column E,

For Ex: For ID 66195 in column H, the PBRK1 time should be 10:45 as the max value for 66195 code PBRK1 is 31 and the time against that is 10:45.

Hope the example helps.

hope this helps