professorTee1FOUR IMPORTANCE OF XLOOKUP1.Lookup functionality: The XLOOKUP function in 1. Excel is a powerful tool that allows users to search a range or array for a specific…Mar 23Mar 23