Take the name of a contact

Good morning.

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

Chemi

Answers

  • Michael Pappas
    Michael Pappas ✭✭✭✭

    If I understand correctly, you are trying to use department to get a name as text from a contact cell. If that is correct, you should be able to use VLOOKUP to return the name as text as long as the column with the VLOOKUP formula is a TEXT/NUMBER column. For example,

    =VLOOKUP(Department@row, {Sheet 1 Range}, 2, false) where the column with this formula is a TEXT/NUMBER column and Column 2 in Sheet 1 Range is a Contact Column.

  • Thanks for the answer Micahel.

    I try to explain it with the attached image.


    • In the sheet below I make two vlookups, one of them with the email from the contact and the name from the contact.
    • The formula with the name works

    =VLOOKUP(CONTACT@row; {test 2 Rango 2}; 3; false)

    • The formula with the email doesn't work

    =VLOOKUP(CONTACT@row; {test 2 Rango 1}; 2; false)


    thanks in advance

    Chemi

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!