Excel Vlookup

[MahanteshS]

I want to do Excel Vlookup, but result i am getting from Alteryx and manual vlookup is different, 

I tried with using "JOIN" & "Multi JOIN" tools but still not getting expected output

Can i pass the below formula directly to Alteryx??

vLookup Formula "=VLOOKUP(B2,'Application User List'!E:F,2,0)"

Please help me guys, ASAP

[Gowthamrajas]

Give a Try with Find and Replace tool. Use Append Options to add up the
second table columns..

[MahanteshS]

Is there any possibility can i pass the vlookup formula directly??

[Gowthamrajas]

Alteryx and Excel follows its own coding standard in reading a file.

So you cannot dirrectly do it..

Find and replace can help you with append options..

Alteryx help have a very good example for Find and Replace explanation.

[MahanteshS]

Find and replace is giving an error saying "Source has records more than 16"