vlookup

[Crypto_raccoon]

hey! i have stumbled upon trying to do my task with find replace tool. i have =VLOOKUP($BA184,WWNG!$A:$H,7,0) formula in excel how do i make it happen with a join tool? thank you in advance!

[Emil_Kos]

Hi @Crypto_raccoon,

I would recommend watching this video.

I think this might help:

https://www.youtube.com/watch?v=3g0XI7rzMPo&ab_channel=Alteryx

[Crypto_raccoon]

Thank you, i'll try to get through it if you have any more info regarding this topic it would be much appreciated

[Emil_Kos]

Hi @Crypto_raccoon,

Alteryx is using column names instead of ranges like excel.

In order to make your transformation happen, we would require a sample data set to make it work for you.

Without that, you need to do it yourself but I believe you will manage. It should be relatively simple.