Alteryx Excel Automation

[kunalkhanna1132]

I would like your steps input on how to automate this excel formula of a column using Alteryx.

Cell B2 =IFERROR(INDEX('Fact'!D:D,MATCH(NUMBERVALUE(AG2),'Fact'!AE:AE,0)),"")

Where Fact is another excel sheet in the same workbook, AE and E are columns in Fact and AG is another column in the worksheet in which the formula is written.

Thanks.

[aatalai · Accepted solution]

@kunalkhanna1132  I would bring both tabs in as seperate inputs and use a join tool or find and replace, let me know how you get on

[kunalkhanna1132 · Accepted solution]

Okay Will get back to you. Thanks!