Skechers U.S.A. Interview Question

How does xlookup work in Excel?