Lookup Function (Formula)

  • 20 October 2020
  • 2 replies
  • 8 views

Badge +2

Hi,

In my Nintex Form, when the requester selects the Country, based on the selection a text field has to get show if it is LatAM or NAM, The country is list of United States (Includes Canada) and Latin American Countries.

I have used the syntax as lookup(Country,Title,Country,Region) i am very much aware that this is incorrect.

The Country List has the Country Names in the Title Column and the Region with LatAM and NAM values.

I am using a Calculated Value.

Kindly assist me on this.

Thank you in advance.

 

2 replies

Userlevel 6
Badge +22
Hi,

Looks almost right.
lookup(list title, column to filter on, value to filter on, output column)
so
lookup("Country","Title",NameOfTheCountryControlNoQuotes,"Region")
Badge +2

Hi Simon,

Thank you, i know i was mucking in the Syntax.

That solved my issue.

Reply