I am after an equivalent in Alteryx to the formula VLOOKUP with the column_index_no field taking different values per row for example:
VLOOKUP(CELL,ARRAY,MATCH(CELL2,ARRAY2,0),0)
I am able to use the find and replace tool if the column_index_no field is fixed i.e. not a match formula. I have tried (and failed) to do this with a join tool.
I have attached a sheet1 and sheet2 for ease of use into alteryx builds, in addition to the sheet1 - excel working to illustrate my problem.
Would be amazing if this could be solved as it would mean an entire function of my role could be done within minutes instead of hours!
Thanks
Solved! Go to Solution.
Thanks Ben much appreciated