Hi!
I am trying to recreate an excel formula in Alteryx. The formula is as follows: "=IF(ISBLANK(AP2),VLOOKUP(H2,LegalEntity!A:L,12,FALSE)," & _
"IF(AN2=AP2,VLOOKUP(H2,LegalEntity!A:L,11,FALSE)," & _
"VLOOKUP(H2,LegalEntity!A:U,21,FALSE)))") .
I believe the statement is saying: if column AP is blank, then vlookup 1. If column AP = column AN, then vlookup 2. Else vlookup 3.
I know how to create the vlookups in Alteryx, but I am not sure how to set specific criteria that would result in a specific vlookup.
Any help is appreciated!!
Solved! Go to Solution.
You could use the find and replace tool to do all 3 vlookups and append the corresponding columns, and then implement a formula tool afterwards with the logic that you have specified.
IF IsBlank([AP])
THEN [VLOOKUP 1]
ELSEIF [AP] = [AN]
THEN [VLOOKUP 2]
ELSE [VLOOKUP 3]
ENDIF
This was perfect!! Thank you so much!!