IF ERROR

Question

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.

V.xlsx

Treyson · Accepted Answer

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