Index / Match? TO RETURN AN ADJACENT CELL TO A MAX FORMULA

[ollyhughes1982]

[FONT=&quot]Hi. Please see Excel spreadhseet via link.

https://1drv.ms/x/s!AtIvkRgReIvwgQsRvSATK0IvdCRG[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Please can someone help me with this, as I have tried and tried to get it working, without success. In column AV I want to return the value relevant to the column AW. Column AW will return the age-grade that is the highest out of the 8 sub-events for event #4 . I have managed to get the columns to the right working, but cannot get it to display the relevant column to the left.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]For example, I have highlighted cell AV33, in this cell I want it to return the value from cell T33 (00:12:00), i.e. the cell value to the left of the cell U33. I cannot see what I am doing wrong.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I have only done this for line 33 at the moment, just for this example, I will then want to fill it up and down for the whole column.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I also want to do the same exact type of thing in column DT, for event #13.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks.[/FONT]

 

[oldbrewer]

I get a non secure link warning !!!!!!

 

[oldbrewer]

header1	header2	header3	header4	header5	AGEGRADE
33	44	55	66	77	9
		what do you want amend this to show us

<colgroup><col span="7"></colgroup><tbody>
</tbody>

 

[ollyhughes1982]

Please try this link?

https://1drv.ms/x/s!AtIvkRgReIvwgQsRvSATK0IvdCRG

 

[Fluff]

very difficult to help when the sheets are password protected!!

 

[ollyhughes1982]

Apologies, I forgot I had protected it Please can you try again

https://1drv.ms/x/s!AtIvkRgReIvwgQ0eyBOczf5-P0OJ

 

[Fluff]

Try formatting the cell to time.

 

[ollyhughes1982]

Thanks. Sorted now.

 

[Fluff]

You're welcome & thanks for the feedback