Filtering values in lookup column based on cell values

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.

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?

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

1 Like

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.

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