# Is Included In **URL:** \ **Category:** Ask for Help\ **Created:** [May 5, 2025, 4:24pm UTC](https://community.glideapps.com/t/is-included-in/81716 "2025-05-05T16:24:01Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 5, 2025, 4:24pm UTC](https://community.glideapps.com/t/is-included-in/81716/1 "2025-05-05T16:24:01Z")
How does “Is Included In” _actually_ work when comparing? In table 1 (Target Accounts) I have "GUITAR CENTER HOLDINGS " and I am comparing the row to table 2 (Partner Accounts) which matches 5 records: 2 entries "GUITAR CENTER HOLDINGS " and 3 entries “GUITAR CENTER” I have lots of other records with “CENTER” and “HOLDINGS” and it doesn’t match those. But it does pick up “GUITAR CENTER” Not sure what logic/magic drives the ‘is Included In’? Actually the results are what I want; I just don’t understand why. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44f6709b8f7e87417f5dbe2c0814d62bc13ba9c4.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 5, 2025, 4:26pm UTC](https://community.glideapps.com/t/is-included-in/81716/2 "2025-05-05T16:26:55Z")
The text strings “ **Guitar Center** ” AND “ **Guitar Center** Holdings” are included in the text string “ **Guitar Center** Holdings”. How are you structuring the comparison? Which table is table 1 and which is table 2? Based on your screenshot, I assume the screen value is the Guitar Center Holdings and each matching table value is included in that screen value. Maybe you want to use Includes instead??? ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 5, 2025, 4:43pm UTC](https://community.glideapps.com/t/is-included-in/81716/3 "2025-05-05T16:43:35Z")
I am comparing "Guitar Center Holdings " in Target Accounts (with a space at the end) against the values in Partner Accounts. In Partner Accounts there are three rows with “Guitar Center” and two with "Guitar Center Holdings ". So I have 2 exact matches and 3 ‘fuzzy’ matches (“Guitar Center”) But plenty others with “Center” and “Holdings” do not match which is the confusing part. Shouldn’t they match too? I actually get the result I want (all Partner Accounts that include “Guitar Center”) but since I started the search with "Guitar Center Holdings ", I am surprised it worked how I wanted since I other accounts would have matched ‘Center’ and ‘Holdings’ but did not. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 5, 2025, 4:47pm UTC](https://community.glideapps.com/t/is-included-in/81716/4 "2025-05-05T16:47:45Z")
> [@MattLB](#): > > But plenty others with “Center” and “Holdings” do not match which is the confusing part. Shouldn’t they match too? If the values are only “Center” and only “Holdings”, then yes I would expect them to match as well, but if they are something like “X Center” or “Y Holdings” then I would not expect a match because “X Center” and “Y Holdings” don’t exist in the string “Guitar Center Holdings”. **Included In** = a left to right match. (Values in rows being searched are _Included_ somewhere _In_ the search text) **Includes** = a right to left match. (Values in rows being searched _Include_ the search text somewhere within themselves) ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 5, 2025, 4:52pm UTC](https://community.glideapps.com/t/is-included-in/81716/5 "2025-05-05T16:52:47Z")
I will test it out. Thanks Jeff. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 6, 2025, 12:22pm UTC](https://community.glideapps.com/t/is-included-in/81716/6 "2025-05-06T12:22:00Z")
Thanks again Jeff. Tested a few and you are correct. It is just a little weird to think Guitar Center Holdings is “Included In” Guitar Center but it works out. Guitar Center Holdings is included in: Guitar Center Holdings Holding Center Hold Center Holdings Guitar Cen Ter Hold Tar Cen Cent It is not included in Guitar Holdings TarCen GuitarCenter ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 6, 2025, 12:56pm UTC](https://community.glideapps.com/t/is-included-in/81716/7 "2025-05-06T12:56:02Z")
> [@MattLB](#): > > It is just a little weird to think Guitar Center Holdings is “Included In” Guitar Center but it works out. I think you are still picturing it backwards. “Guitar Center” is included in “Guitar Center Holdings”. Not the other way around. If you read it left to right like a sentence, then it makes sense. That’s why I mentioned maybe using **Includes** instead of **Is Included In** , which might make more sense for your use case. You want to find matches that **Include** your search term instead of finding matches that are **Included In** your search term. But maybe I’m misunderstanding the goal. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 6, 2025, 1:39pm UTC](https://community.glideapps.com/t/is-included-in/81716/8 "2025-05-06T13:39:19Z")
I never actually understood how it worked - my bad since it seemed somewhat counter-intuitive - but it works as I needed/hoped it would (matching names that are close but not exact). Thanks for the color on its operations. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 13, 2025, 1:39pm UTC](https://community.glideapps.com/t/is-included-in/81716/9 "2025-05-13T13:39:38Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.