I'm trying to figure out how to perform an excel like vlookup search in construct.
Here is the pathway i would like to take
User types last name into text box
Text box entry is set to global variable "nameentry"
On search button clicked - search "nameentry" in Array column 1
If nameentry finds a match in column 1, output the row number in which it was found
Set global variable "rownumberofname" = to the search output (row in which "nameentry" was found)
Can anybody help with this?