Excel Formula to Alteryx

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.

Help

Accepted answers

All comments

Deano478

Hi @Gaurav0001 can you provide some sample data so people can try and create the desired result?

FrederikE

Hey @Gaurav0001,

A VLOOKUP can be done in Alteryx by using a join/Find&Replace tool to connect the two data sources.

See: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Alteryx-for-Excel-Users-How-to-do-a-VLOOKUP-in-Alteryx/ta-p/37953

Gaurav0001

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.

Test.xlsx

cjaneczko

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.

Gaurav0001

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.

cjaneczko

In that case you would want to place a Unique tool in front of the Join for P_M. This will only grab the first iteration of PC. Find attached a sample workflow.

Test.yxmd

Gaurav0001

Hello @cjaneczko,
Hope this solution will work, Thanks for the Help.😊

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335