The XMATCH function was introduced to Microsoft Excel ... exact match, and it lets you search from the top downwards and the bottom upwards. What's more, XLOOKUP also lets you include an "if not ...

How to use VLOOKUP() to find the closest match in Excel Your email ... the lookup range (but not necessarily the first column in the data set). When it doesn’t find an exact match, it stops ...