SOLVED

# Finding a date that is linked and adjacent to a number

Brass Contributor

# Finding a date that is linked and adjacent to a number

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

4 Replies
best response confirmed by Clive_Rabson (Brass Contributor)
Solution

# Re: Finding a date that is linked and adjacent to a number

In AT3:

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

Fill down.

# Re: Finding a date that is linked and adjacent to a number

I am very grateful

# Re: Finding a date that is linked and adjacent to a number

Alternative:

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

# Re: Finding a date that is linked and adjacent to a number

Once again many thanks for your help with this project
1 best response

Accepted Solutions
best response confirmed by Clive_Rabson (Brass Contributor)
Solution

# Re: Finding a date that is linked and adjacent to a number

In AT3:

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

Fill down.