Replicate VLOOKUP against Index Number

[Andrew_Seaman]

I am attempting to replicate the following process from Excel into Alteryx:

Table_1:

Table_2:

Join/Lookup I need to replicate:

Essentially the Key get's replicated using the VLOOKUP, but I am unsure how to do this in Alteryx I tried using the JOIN/APPEND Tools so far.

[Emil_Kos]

Hi @Andrew_Seaman,

This is one solution that you can use:

The only difference is the output for the empty position it will just stay empty instead of 0

To my best knowledge, you cannot use approximately join as in the vlookup. My approach was to create a row for each of the value of the index. 

[Tyro_abc]

Hi @Andrew_Seaman 

Try this..

[Tyro_abc]

Hi @Andrew_Seaman 

You can try this...

 Best Regards 

Arundhuti