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

microwin88x — Thu, 27 Mar 2014 18:57:27 GMT

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 — Thu, 27 Mar 2014 18:58:46 GMT

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

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

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