community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

IF THEN VLOOKUP Statement

Asteroid

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!!

Alteryx
Alteryx

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

Asteroid

This was perfect!! Thank you so much!!

Labels