Return several values via a vlookup

Mberhin ✭✭
edited 03/29/23 in Formulas and Functions

Hello all, is it possible in smarsheet to use a vlookup that would return several values in the same cell. I have a sheet with the list of users and the departments they belong to. I then have a sheet with the tasks of a project with a column that contains the users in charge of a task, each cell allows the addition of one to several users, would it be possible via a formula to display in a second column the department(s) corresponding to the task owner.


Matthieu 😅



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!