It appears the example has a bug, it always searches for “Groceries”, whatever value one enters in the text-box. If I change this: searchRange.find($("#searchText").text(), { to searchRange.find($("#searchText").val().toString(), { the example works as expected.