Vlookup False Values

[bhavsarsangam106]

Hi All,

I want to do a v-lookup in sheet2 with another spreadsheet (sheet1) and want to get results as unique values (#N/A)

request you please check the spreadsheet I've attached.

require data - sheet2 highlighted column 

[DawnDuong]

hi @bhavsarsangam106 

you can use the Join tool for this with the L and R anchors set to point to the respective columns you want to match between the sheets. The output anchor L gives you the records (i.e. rows) that only exist in input L but not in input R. Likewise, the output anchor R gives you the records that only exist in input R but not in input L. 

The following link Vlookups with Designer gives the full step-by-step detailed guidance on how to get started with this tool if you are new to Alteryx Designer.

Cheers,

Dawn.

[aatalai]

you can also look at the find and replace tool

[nagakavyasri · Accepted solution]

@bhavsarsangam106  try this:

[bhavsarsangam106]

thank you so much