Conditional lookup

Question

Hi Team,

I am able to achieve the following output in Excel using conditional lookup refer to Calcs tab, and I want to achieve the same in Alteryx

Test_C.xlsx

RaviPM10 · Answer

Thanks @OTrieger do you have any sample workflow which i can refer, it would be helpful

OTrieger · Answer

@RaviPM10 
What you will need to do is creating flags such as true/false for the IF statement in the excel file. I can see that there is also OR statement nested in the IF. So you need a field in Alteryx that indicate which condition need to be applied. Simple mapping such as a, b, c, or 1, 2, 3 and then based on that field you can update the values as needed, you can use Find and Replace or Union tool for the Vlookup.

So as long that you understand the formulas in the excel file you be able to built that logic in a formula tool.