Filtering values in lookup column based on cell values

1

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
image1006×1174 32.9 KB

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?

2

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

image
image679×537 50.9 KB

1 Like
3

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.

4

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