IF ERROR

[Kinetic_analytics]

Helllo:

How can I transform following IFERROR VLOOKUP into Alteryx. 

=@IFERROR((IF(AD2<>0,VLOOKUP(AD2,'User List'!A:B,2,FALSE),VLOOKUP(Vlookup!N2,'User List'!A:B,2,FALSE))),Unknown)

I have attached file for data.

Instruction: Need to figure out Colum "T" of VLOOKUP sheet. 

To solve T need to consider, AB, AC,AD column formulas. 

[Treyson · Accepted solution]

Iferror really works to help remove that #N/A value. Since we don't have that in Alteryx there area few ways to figure this out.

I think the easiest way to do this would be to have a filter tool, where you send every record where AD does not equal 0. Then apply your logic to the records coming out of the T/F sides.

Example Attached

[Kinetic_analytics]

Thank you.