value match function

[santhosh_k_n]

Hi all,

I am having 2 columns and am making selection in one of the column.

I need the function to get the matched values in the second column based on first column selection.

Please guide

[MK_QSL]

Please provide some sample or apps

[santhosh_k_n]

Consider Below table:

Report type	report name	sheet ID
Type1	report1	sheet2
Type1	report2	sheet2
Type1	report3	sheet2
Type2	report4	sheet3
Type2	report5	sheet3
Type2	report6	sheet3
Type2	report7	sheet3

In above table, if i select report name i need to assign the matching report type to a variable.

say, I had selected report name = report3, then i need to assign report type - Type1 to a variable V_temp

Hope you understand

[tresesco]

Define your variable like:

V_temp= [Report type]

[MK_QSL]

Create a variable

vVar

=Only({<[report name] = {'$(=GetFieldSelections([report name]))'}>}[Report type])

Now use vVar in Text Box and Try to Select report name

[its_anandrjs]

Update now check

Write a variable like

V_temp =if(Match(GetFieldSelections([report name]),'report1','report2','report3'),'Type1',

              if(Match(GetFieldSelections([report name]),'report4','report5','report6','report7'),'Type2'))

[SunilChauhan · Accepted solution]

I am agree with tresesco .

see the attached file