map values based on ther values of different field

[saumyashah90]

Hi i have table

Header 1	Header 2	Header 3
abc	1	Hi
def	2	Hello
ghi	3	Bye

i want to use some function in a text box by which when i click on Hi i should get vale abc

same if i click on hello i shouls get def and if i click on Bye i should get ghi value in a text box

[kaushiknsolanki]

Hi,

     Try below expression in textbox.

     =only(Header1)

Rergards,

Kaushik Solanki    

[saumyashah90]

Hi kaushik,

Its not working.

[saumyashah90]

The table shoed before is data provided.

Now i have header3 in a list box and i want value linked with header3 in header1 in a text box(To be more specific)

[kaushiknsolanki · Accepted solution]

Hi,

     It will show only if you select any value, if you dont select anything it will be null.

     Or you can also use the Maxstring() function.

      Have a look at the application attached.

Regards,

Kaushik Solanki