IF and VLOOKUP

Question

Hi, I would like to ask how to write below formula in Alteryx workflow.

I have two different Excels and one common indicator in both Excels. So if cell in collum K empty the Alter should take data from other Excel with common indicator which is in the first column (column A) and export the relavant commnon data from second column to new Excel.

=IF(K7="";VLOOKUP(A7;Table1;2;FALSE);DATA!K7)

Thank you.

AngelosPachis · Answer

Hi @denisstravs ,

I've tried to mock something up for you. The two inputs that feed into the Find & Replace tool are your two different sheets

Let me know if that worked for you.

Cheers,

Angelos

sample_workflow.yxmd

AngelosPachis · Answer

Hi @denisstravs ,

Can you attach some mock data please of the two excels?

Thanks,

Angelos