an Defaults Function the The Xlookup Function Defaults to an Exact Match. By Ra_Shayla515 11 May, 2022 Post a Comment The formula MATCH40102040500 returns the value TRUE. Beep-boop I am a helper bot. Xlookup Syntex Micr…