Index match / contains formula

[ML123]

I have a question about how to find a string in a field.

Example:

Column A	Column B	Solution
1	1	1
1	11	1
2	2	2
2	22	2
3	3	3
4	4	4

The Excel formula would be: =INDEX($B$2:$B$6,MATCH(A2,$A$2:$A$6,0))

I have tried to 

[CharlieS · Accepted solution]

The process performed by the expression above is the Index and Match are finding the values in Column B that match each record of Column A and returning the value of Column A at that match. 

The process can be replicated using the Join tool in Alteryx. The Match part of the Excel expression is controlled by the "Join by Specific Field" settings at the top of the Join tool configuration/ To replicate the Column A return at that match, I changed which fields are output from the Join tool by selecting the Column A to be returned from the right, or matched record. I renamed this field "Solution" as well to make this clear. 

Check out the attached example and let me know if you have any questions.