Google Sheets matching zip key string to a zip key

How To
1
  1. I format zip keys based on unclaimed projects into a string that looks like this 43, 45, 45, 45
  2. The Google Sheets will have users with one or multiple of the Zip Keys in the string.
  3. If the Zip Key string is included in the users Zip Key I need to return the users.

Nothing I have done so far works, you would thing a text operator contains would work but it does not.

User Sheet:

image
image810×754 50.6 KB

Failed Filter Attempt:

image
image445×728 28.5 KB

2

Welcome to the Make community!

What is the value of 56.text?

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!