TL;DR: To use Excel lookup functions, pick VLOOKUP for compatibility with older Excel (2019 and earlier), and XLOOKUP for new…