How to search name ('first name' 'surname') in an excel file with two columns A - first name, B - surname.
Not to use Concatenation please as surname may be incorrectly input as first name.
Thanks.
Userlevel 4
+8
Hi @Sonny Yuan ,
- Use the Loop get the data from A or B Column values stored into the variable
- Use If conditions, A column value is matched with input value get the B column value, If not matched then skip loop the next values.
Above case, you're using the First name, so use the B column value is matched with input value then get the A column value, Also check the A column value after the matched.
in Step1 - what type of variable you would recommend to use please.
Thanks.
~@Tamil Arasu Thanks Tamil. The solution is what I after.
Userlevel 4
+8
No problem!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.