Take the name of a contact
I would like to take the name of a contact in a contact list column / or take the email.
For example, we have in a sheet a list of workers, name, email, department.
On the other hand we have another sheet with a formular where we collect their emails (or name).
I need to take with vlookup the department (or other data) from a worker having his name (or email) from the contact column.
I tried to use a lot of formulas but I'm not able to make it. When we have in a fied the name and the email, Smartsheet don't return us the value. Even I tried to get the email or name in another cell from a contact cell, and nothing.
Thanks in advance