ISERROR VLOOKUP Statement

Hi!

I am trying to recreate the excel function; ISERROR VLOOKUP in Alteryx. The formula that I am trying to re-create looks like this: =IF(ISERROR(VLOOKUP(G2,'FIS Matrix'!G:H,2,0)),0,(VLOOKUP(G2,'FIS Matrix'!G:H,2,0))) . The formula is searching for entries in column G in the tab FIS Matrix that match entries in column G of the current sheet and returning the value found in column H of FIS Matrix. If the value is not found, "0" will be the return, instead of the #NA error.

Is there anyway to recreate this in Alteryx?

Any help is appreciated! Thanks!

Preparation

Accepted answers

Thableaus

Hi @grsomer

To recreate the VLOOKUP function in Alteryx you can use either the Join Tool or the Find and Replace Tool.

After that, to treat the values not found you can use a Formula Tool.

Do you have some sample data so we can give you an example?

Cheers,

All comments

Thableaus

Hi @grsomer

To recreate the VLOOKUP function in Alteryx you can use either the Join Tool or the Find and Replace Tool.

After that, to treat the values not found you can use a Formula Tool.

Do you have some sample data so we can give you an example?

Cheers,

Loic

Hi @grsomer Check this guide out: https://www.alteryx.com/alteryx-excel

Towards the middle of the page it explains how to do the equivalent of a VLOOKUP() in Alteryx simply using the join tool.

You might want to create an additional field with a formula once the join is done.

kelsey_kincaid

Here's an example of how to accomplish what you're trying to do using the FIND/REPLACE tool and the Data Cleansing tool. You could use a Formula tool in place of Data Cleansing if you wanted the unmatched values to return something other than 0.

VLOOKUP-IFERROR Example.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703