IF and VLOOKUP

[denisstravs]

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]

Hi @denisstravs ,

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

Thanks,

Angelos

[AngelosPachis]

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