INDEX/MATCH FORMULA? URGENT HELP

Hello I'm trying to recreate the formula below in Alteryx.

IF(INDEX('Client'!$A:$I,MATCH($AI3&$AL3,'Client'!$A:$A&'Client'!$B:$B,0),2)<>"","Yes","No")

Someone suggested I use a transpose tool but I'm not really familiar with the tool.... What confuses me most about this formula is the multiple lookup values in the MATCH portion and the multiple lookup arrays......... Please help.

Tips and Tricks

Best Practices

Transformation

Dynamic Processing

Accepted answers

MarqueeCrew

@Davidmcho,

What we did was Select the key (recordID) and the 2 fields that you wanted to match on from [input1] and selected the UNIQUE value combinations of the 2 fields from [input2] and joined the data on those 2 fields as keys.

Data that comes out of the L file was given a new variable with a value of "No" and data from the J output was given a value of "Yes" for the same variable name. We took the L and J data into a Union and then selected the RecordID and the Index result as the only output fields. We then joined this data back to the original [Input1] data stream (removing duplicate fieldname of recordid).