# Lookup Multiple Values from One Cell / Many-to-Many Relation

**URL:** <https://community.glideapps.com/t/lookup-multiple-values-from-one-cell-many-to-many-relation/66456>\
**Category:** Ask for Help\
**Created:** [September 23, 2023, 12:13pm UTC](https://community.glideapps.com/t/lookup-multiple-values-from-one-cell-many-to-many-relation/66456 "2023-09-23T12:13:44Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Raphael\_Aebersold](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raphael_aebersold/32/64167_2.png) [@Raphael\_Aebersold](https://community.glideapps.com/u/Raphael_Aebersold)\
**Post date:** [September 23, 2023, 12:36pm UTC](https://community.glideapps.com/t/lookup-multiple-values-from-one-cell-many-to-many-relation/66456/5 "2023-09-23T12:36:08Z")

</div>

Hi [Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy),

You helped me find the solution! But not the way I expected, cause what you just mentioned was exactly the way I’ve tried it.

However, the thing is, that if I refer to split value columns subsequently, the glide app does something weird (or at least I don’t get it).

It only ever uses the split values correctly if I copy a whole column and paste it at the same place again. On the bottom I can always see an “updateing” indicator. (This worked, however!) 🙂

So I guess glide just doesn’t refresh data when a new column is added?

It’s exactly the same issue with filters:

> [@Identical filters after added row although "Split Value" Column is used for filtering](https://community.glideapps.com/t/identical-filters-after-added-row-although-split-value-column-is-used-for-filtering/66438/3):
>
> Hi [ThinhDinh](https://community.glideapps.com/u/ThinhDinh), Sure, I struggled explaining it properly, sorry. Image 1: I have a table with a filter. The filter is called “Ziele”. Image 2: I pull the items for the filter from a split text column. The text to be split is taken by the column right next to it – a column with comma separated values. To put it in context: all this information so far is in the main table i’m using for the app. In order to collect user data, however, I have a different table (“new entries”) so i can check entrie…

Anyhow, thanks for your help and if you know if there is a way to automatically update a table after a column has changed / calculated something then please lemme know.

---

_[View the full topic](https://community.glideapps.com/t/lookup-multiple-values-from-one-cell-many-to-many-relation/66456)._