Adding a space between 2 vlookup functions

edited 12/09/19 in Formulas and Functions

Hi All,


How can you add a space between 2 vlookup functions?

Here's the formula: =VLOOKUP(Alias247, {Pilot Data Base Range 4}, 3, false) + VLOOKUP(Alias247, {Pilot Data Base Range 4}, 2, false)

This will show First_NameLast_Name.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!