XLOOKUP is a powerful new function in Excel that allows you to search for a specific value in a range and return a corresponding value from another column. It's simpler than the traditional VLOOKUP and HLOOKUP https://learnproexcel.com/how-to-use-xlookup-in-excel/