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]

[TABLE="width: 448"]
<colgroup><col span="7"></colgroup><tbody>[TR]
[TD]header1[/TD]
[TD]header2[/TD]
[TD]header3[/TD]
[TD]header4[/TD]
[TD]header5[/TD]
[TD="colspan: 2"]AGEGRADE[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]what do you want amend this to show us[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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