This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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-
@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.