Xlookup searches for a value in a range for a match and returns the item corresponding to the lookup values from another range of cell. =XLookup(Lookup Value, Lookup Array, Return Array) 1) Lookup Value - The value you are searching for 2) Lookup Array - The range of cells where you want Excel to search for the Lookup Value 3) Return Array - The range of cells from where Excel returns the final value ❤️ and follow for more Excel tips #excel #microsoftexcel #msexcel #office365 #officeproductivity