Perform Vlookup Style Array search

Get help using Construct 3!

Post » Sun Jul 30, 2017 7:32 pm

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
B
4
Posts: 20
Reputation: 240

Post » Sun Jul 30, 2017 7:56 pm

rownumberofname =Array.IndexOf("nameentry"), assuming that "nameentry" is stored on the X-index.
B
33
S
18
G
28
Posts: 2,493
Reputation: 20,950


Return to How do I...?

Who is online

Users browsing this forum: newt and 1 guest