Lookup a caption from table

[alerse]

Hi

I'm trying to get a caption for a text object from a simple table. E.g.

Object Name Caption

Name1 Caption for name 1

Name2 Caption for name 2

What should the expression be? I've tried

=(if([Object Name]='Name1',[Caption],0))

But that didn't work... Somehow I need to search through the table?

Your help will be appreciated!

Eon

[Anonymous · Accepted solution]

Your solution needs to have one value returned. Try this:

=

Maxstring(If([Object Name] = 'Name1',[Caption]))

[alerse]

perfect, thanks so much!!