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.
Solved! Go to 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
Thank you.