# Filtering values in lookup column based on cell values

**URL:** <https://connect.superhuman.com/t/filtering-values-in-lookup-column-based-on-cell-values/26391>\
**Category:** Ask the Community\
**Created:** [October 21, 2021, 7:06pm UTC](https://connect.superhuman.com/t/filtering-values-in-lookup-column-based-on-cell-values/26391 "2021-10-21T19:06:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aachal\_Garg](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aachal_garg/32/17397_2.png) [@Aachal\_Garg](https://connect.superhuman.com/u/Aachal_Garg)\
**Post date:** [October 21, 2021, 7:06pm UTC](https://connect.superhuman.com/t/filtering-values-in-lookup-column-based-on-cell-values/26391/1 "2021-10-21T19:06:55Z")

</div>

Hey, I have 2 tables

Table A - Manager  
Table B - Emp, Manager

I have made Manager (field in Table B) as a lookup column referring to Manager (field in Table A). I want to filter the lookup picklist for each cell so as to exclude the Emp name in that row.

 ![image](https://global.discourse-cdn.com/coda1/original/3X/1/a/1a414df3f958dc4acb0808e1329198f8fb6e8053.png)

As per the above example, for first Emp “AB”, There should be only 2 options showing as “CD” and “EF” instead of 3. I have been trying to use the filters but have no success as of now. Can anyone please help?

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [October 21, 2021, 8:40pm UTC](https://connect.superhuman.com/t/filtering-values-in-lookup-column-based-on-cell-values/26391/2 "2021-10-21T20:40:21Z")

</div>

For sure! See the example doc below, but the short answer is this

 ![image](https://global.discourse-cdn.com/coda1/original/3X/a/2/a23a23d2862e3f7ca5d644c66a03e0efd2897ac4.png)

https://coda.io/embed/fuREaaew4j/_suPt2?viewMode=embedplay

---

<div class="post-metadata">

**Author:** ![Aachal\_Garg](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aachal_garg/32/17397_2.png) [@Aachal\_Garg](https://connect.superhuman.com/u/Aachal_Garg)\
**Post date:** [October 22, 2021, 9:31am UTC](https://connect.superhuman.com/t/filtering-values-in-lookup-column-based-on-cell-values/26391/3 "2021-10-22T09:31:25Z")

</div>

Thanks for this. The shared doc is not configured well or atleast for me as I’m unable to see the solution here. But, I understand the formula now.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [October 25, 2021, 9:31am UTC](https://connect.superhuman.com/t/filtering-values-in-lookup-column-based-on-cell-values/26391/4 "2021-10-25T09:31:26Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.