Excel How-to
Case-Sensitive Lookup in Excel and Google Sheets
XLOOKUP, MATCH, and COUNTIF ignored letter case in this test. FILTER with EXACT returned 9.99 for sku-103 and 0.55 for SKU-103 from the same list.
#exact
1 tutorial tagged “exact”.
1 tutorial tagged “exact”.
XLOOKUP, MATCH, and COUNTIF ignored letter case in this test. FILTER with EXACT returned 9.99 for sku-103 and 0.55 for SKU-103 from the same list.