– 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 return any matching row
