IFERROR and Index Match

[Sa743liz-]

Hi how can I do this formula below:

[Emmanuel_G]

@Sa743liz- 

It's complicated to implement it seeing that these functions don't exist in Alteryx.

Please, can you provide some input and desired output so we can test and implement.

[MRod]

The INDEX/MATCH function in Excel is equivalent to the Join tool.  Building off the sample workflow from a Prior Alteryx Discussion. The IF Error portion can be achieved by joining the Left (or Right) output from the Join tool and applying a formula tool followed by a Union to perform a Full Outer Join. See the sample attached.

[Sa743liz-]

Thank you, that works