Show text in textbox

[Anonymous]

Hi all,

I have the following data:

Date	Text
1.1.2012	Hello
1.2.2012	Happy

and I have a selection box for the date.

Now I want to show the Text in a textbox, eg. if slelected 1.1.2012 => "Hello".

How is the command for this?

I only found comands like: sum, aggr, etc.

=sum(Text)

but that doen't work, of course!

Thank you for helping!

[sunny_talwar · Accepted solution]

You can either use

=Text

or

=Only(Text)

or

=Concat(Text)

or

=MaxString(Text)

or

=MinString(Text)