IFERROR AND INDEX AND MATCH combination

[HafeezA]

Hello, how do I recreate this formula in alteryx

=IFERROR(INDEX($Z:$Z,MATCH(B10,$X:$X,0),1),"")

[Luke_C]

Can you provide some sample data? I think using the find and repalce tool's append functionality would work

[MatthewBr]

@HafeezA  - Definitely provide some sample data and the community will certainly help you out! 

[Elias_Nordlinder]

Hello @HafeezA,

I recreated the IFERROR/INDEX/MATCH function in Alteryx.

But with some sample data it is easier to see if this exactly solves your problem.

As mentioned, the Find Replace tool is similar to this combination in Excel.

I used the same column names (X, B and Z) as would be used in those places in Excel 🙂
I added some Sample data.

1. First input (X-column in Excel), use this field as a lookup table for your use case.

This is the field you want to search within.

2. The Z-field and B-field will be used in another table to use.
You want to search for the B-field as in your use case, and if found append the Z-field.

//Regards
Elias