XLookup reusing "old" return value

Hello,

I'm using the xlookup function in order to date the day with a value greater than 450.

The problem is when a value is recurring more than once, it will pick the earliest find instead of the chronologically correct day.

How can i work around this?

See day column jumping from 261 to 25

Skærmbillede 2021-02-17 113458.jpg

(edit: Excel sheet attached)