Forum Discussion

Clive_Rabson's avatar
Clive_Rabson
Brass Contributor
Jun 14, 2024
Solved

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)...
Excel on Mac
dscheikey's avatar
dscheikey
Bronze Contributor
Jun 14, 2024

Clive_Rabson 

Alternative:

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

 

  • Clive_Rabson's avatar
    Clive_Rabson
    Brass Contributor
    Jun 14, 2024
    Once again many thanks for your help with this project

Resources