Forum Discussion

Clive_Rabson's avatar
Clive_Rabson
Brass Contributor
Jun 14, 2024

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

Resources