How to look up by using xlookup, vlookup to locate specific return

[chingg1011]

Hi Expert,

When I use xlookup or vlookup to locate A2 (2 Sep 24), =xlookup("Next day", E:E, A:A), the result return to 1 Sep 24, how can I get 2 Sep 24 ?

Thanks

 

[SunnyAlv]

try to add "Last to First", like

=xlookup("Next day", E:E, A:A,,,-1)