How to know which value is associated to another value without selecting it?

[microwin88x]

Hello!

I have a table with:

- Offices

- Users

And I need the following:

If User = User1, show me the corresponding Office (for example, Office1) WITHOUT SELECTING that User

I tried: =IF (Users = 'User1', Offices) but it works only when selecting the User1

Is there any function to bring that Office for that User in particular?

Thank you!!!

--

Should this work?

[Nicole-Smith · Accepted solution]

only({<Users={'User1'}>} Offices)

But if there could be more than one value in Offices, you need to use:

concat({<Users={'User1'}>} distinct Offices, ', ')