Finding a date that is linked and adjacent to a number

[Clive_Rabson]

I have a simple spreadsheet for which I need a formula in cell AT3 to identify a date that appears next to a corresponding number. For example cell M3 is where the highest number in the row (PeakNum) is found.

Cell N3 contains the corresponding date and it is this date I need the formula in AT3 to show.

Can anyone help please?

I attach the file

[#2 · Accepted solution]

@Clive_Rabson 

In AT3:

=INDEX(F3:AP3, XMATCH(AS3, E3:AO3))

Fill down.

[#3]

I am very grateful

[#4]

@Clive_Rabson 

Alternative:

=XLOOKUP(AS$3,D$3:AQ$3,E$3:AR$3)

[#5]

Once again many thanks for your help with this project