Replicate VLOOKUP against Index Number

Question

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.

Tyro_abc · Answer

Hi @Andrew_Seaman

You can try this...

Best Regards

Arundhuti

Replicate VLOOKUP against Index Number 2.yxmd

Tyro_abc · Answer

Hi @Andrew_Seaman

Try this..

Replicate VLOOKUP against Index Number.yxmd

Emil_Kos · Answer

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.

Vlookup.yxmd