Case-Sensitive Search in Google Sheet Lookup
  • The Google Sheet Lookup Action now has the capability to do a case-sensitive search in a spreadsheet.
  • By default, "Case Sensitivity Lookup" is disabled, meaning that the lookup will not take into account any case sensitivity.
  • You can enable "Case Sensitivity Lookup" to do a case-sensitive lookup.
Example:
(a) If Case Sensitivity Lookup is disabled:
"John" === "john" is true and returns the matching row
(b)If Case Sensitivity Lookup is enabled:
"John" === "john" is false and does not returns any matching row
GoogleSheetLookup