Not to use Concatenation please as surname may be incorrectly input as first name.
Hi @Sonny Yuan ,
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.
~@Tamil Arasu Thanks Tamil. The solution is what I after.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.