We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close

Dev Space

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

XLOOKUP

AS
8 - Asteroid
‎07-20-2021 04:05 AM

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

Reply
0 Likes
1 REPLY 1
rkapoor
Alteryx
Alteryx
‎07-21-2021 03:27 AM

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

Reply
0 Likes