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

Find more posts tagged with

Accepted answers

All comments

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.

Chemi Pérez

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

error.PNG

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

thanks in advance

Chemi

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.