Excel Formula to Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Please help me to convert Excel VLOOKUP formula to ALTERYX.
Formula : =VLOOKUP(F2,P_M!$A$1:$O$50,2,FALSE)
Over here the Column name PC having this formula. P_M is another sheet in the Excel file.
F column name is PCN for (F2).
I need to make PC column in another sheet with applied Formula ( =VLOOKUP(F2,P_M!$A$1:$O$50,2,FALSE) ) in Alteryx.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Gaurav0001 can you provide some sample data so people can try and create the desired result?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Gaurav0001,
A VLOOKUP can be done in Alteryx by using a join/Find&Replace tool to connect the two data sources.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Deano478
I have provide the sample data (Test) below,
Make sure you apply the formula =VLOOKUP(E2,P_M!$A$1:$C$5,2,FALSE) to PC column in P sheet to get the result in excel.
After, when you get the result like below..
You can try for the solution in Alteryx.
So,
I need to make PC column in another sheet with applied Formula ( =VLOOKUP(E2,P_M!$A$1:$C$5,2,FALSE) ) in Alteryx.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your P_M tab has two different PC for the same PRD. Is it supposed to be like that? Vlookup in Excel will only pick up row 3 and not row 4. Is that your intention? If you use the join tool in Alteryx, it will bring in both row 3 and row 4.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @cjaneczko,
You are absolutely correct,
The row 3 only need to be show as output in Excel, but for Altery I need only Row 3 as output, no row 4.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @cjaneczko,
Hope this solution will work, Thanks for the Help.😊
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)