XLOOKUP

[AS]

Hi,

Help me please

Need to apply XLOOKUP on column "Result". =XLOOKUP([@[Code]],[ABC],[ABC],"NA",0)

Unable to apply the logic for same.

Code	ABC	Result
1400	400	400
1400	NA	400
1431	431	431
1485	485	485
1117	117	117

Thanks in advance

[RishiK]

@AS  this link below will definitely guide you and provide further information, in a step by step fashion of how to replicate the XLOOKUP functionality in Excel:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Replicate-Excel-XLOOKUP-Func...