Excel Formula to Alteryx

[Gaurav0001]

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.

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

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

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

[Gaurav0001]

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