Perform Vlookup Style Array search

Hi Community,

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?

Thank you!

bryan

rownumberofname =Array.IndexOf("nameentry"), assuming that "nameentry" is stored on the X-index.