From Dev.to
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones
XLOOKUP is the newer lookup function, and for a workbook that only people on Microsoft 365 or Excel 2021 and later will open, I would pick it without much hesitation. VLOOKUP still runs in every versi...
