I need Help to Automate this IFERROR VLookup in Alteryx.

[Kinetic_analytics]

I have attached the excel file for your information.

=IFERROR(VLOOKUP(A2,Sheet1!B:G,3,FALSE),"Not Assigned")

[Sebastiaandb · Accepted solution]

Hi @Kinetic_analytics ,

Here you go:

Let me know if this is what you're looking for :-).

Greetings,

Seb

[afv2688]

Hello @Kinetic_analytics ,

a simple join with a formula on the left side would do the trick 🙂

Regards

[Kinetic_analytics]

Thank you.