See how Microsoft failed to fix their lookup problems in Excel 365 XLOOKUP function and how you can address the issue in VLOOKUP, INDEX/MATCH or XLOOKUP using an IF statement.
#xlookup #excel #vlookup