I am working on converting an Excel process to Alteryx and I cannot seem to emulate this Vlookup using Alteryx. The Row column in the Output is hard coded and imported from a template.
The number below C# is the issue age. If the issue age is below 40 the Vlookup will pull from the first table from Inputs. Once the Vllookup pulls that row, the next value it'll pull is the Ult valued based on AA = Issue Age + 25. Then it'll copy down the whole Ult row until it reaches AA 120. AA116-AA120 are exactly the same as AA115. Now if the value below C# is >=40 the Vlookup pulls from the Age40 row and does the same process.
