Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Similar to SQL :
select F2 where F1='test2'
the result in to the text box should be Canada
Thanks
Hi,
Try this inside text box: =If(F1='test2', F2)
Regards,
H
Thanks. I did it with Aggr function as actual data has more grouping.