Multiple criteria in a row for VLOOKUP


I am trying to create a report from data with multiple criteria in a row. The objective is to return the residual risk value for each combination of risk + strategic initiative. In Excel, I was able to accomplish what I am looking for with this formula (=VLOOKUP(CONCATENATE(D$2,"-",$B36),'FY 2020 ERM Assessment'!$A$11:$W$410,17,FALSE). In the table, I had to create a 'helper' field (=[@Initiative]&"-"&[@Risk]) to enable this formula to work. 


In Smartsheet, I can create the helper field, but there doesn't appear to be the ability to use the CONCATENATE function. Does anyone know a workaround? 


Thank you, 


 - Eric 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!