Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!

XLOOKUP

AS
8 - Asteroid

Hi,

Help me please

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

Unable to apply the logic for same.

 

CodeABCResult
1400400400
1400NA400
1431431431
1485485485
1117117117

 

Thanks in advance

1 REPLY 1
RishiK
Alteryx
Alteryx

@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...