Show result based on condition (not based on selection)

[Karl_Hart]

I'm trying to have a text box that shows the description of a specified code

I want to write something along the lines of

=[PI Description] where [PI Code] = 'GK300'

This will always show the Description of the Code GK300.

What I dont want to do (but it works) is

=If([PI Code]='GK300', [PI Description])

as this will only show the description if GK300 is selected.

I hope this makes sense. Any ideas?

[simenkg · Accepted solution]

only({$<[PI Code]={'GK300'}>}[PI Description])

[Karl_Hart]

Thanks, I've not come across the "only" function before. I'll read up on it.