Excel Vlookup conversion

[mquast]

I am working on converting an Excel process to Alteryx and I cannot seem to convert this Vlookup. The Row column in the Output is hard coded and imported from a template. 

[tristank]

Hi mquast hope you are well.

Are you trying to emulate the vlookup formula in Alteryx? I am a bit confused as to what your ask is. Any context is much appreciated!

Vlookup Mapping in Excel to Alteryx

[mquast]

@tristank Yes, I am trying to emulate the Vlookup formula in Alteryx. 

[mquast]

@tristank 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.