Closed govert closed 5 years ago
When XMATCH or XLOOKUP is called with match_type 0, wildcard characters should be found - currently this fails in the XFunctions implementations.
So the lookup_value "WalMart" does not find "WalMart" with match_type 0.
Fixed with commit 419b835601f208224a41ef0f37064ef798750e5b in v0.2-alpha.
When XMATCH or XLOOKUP is called with match_type 0, wildcard characters should be found - currently this fails in the XFunctions implementations.
So the lookup_value "WalMart" does not find "WalMart" with match_type 0.