ISERROR VLOOKUP Statement

[grsomer]

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!

[Thableaus · Accepted solution]

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.