Tip of the month: October
A new Excel trick every month. Come back next month for another one.
Meet XLOOKUP
In Microsoft 365, =XLOOKUP(what you are looking for, where to look, what to bring back) replaces VLOOKUP and can look in any direction. It is one of the favourites on my Advanced course.