Apply Xlookup the same table

[AS]

Hi,

I'm stuck on a point when Excel has a function XLOOKUP and I could not able to apply the logic. Could you guys help me-

This is the lookup formula i need to apply on result column =XLOOKUP([@[Code]],[ABC],[ ABC],"NA",0)

Expected result would be- 

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

[rkapoor]

@AS I have just replied to your other post on this.  Have a look at the link below,

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

This is a good step by step guide to support you to get to your expected output or know more on how to replicate the XLOOKUP in Alteryx.