Can you preserve the contact list data type (email) across a reference/lookup formula??

Hi all,

So, I am trying to pull in a value from a contact list through a reference sheet. The two formulas below are pulling the correct values, but the values retrieved are converting the contact list email into what appears to be a contact's name as a text field.

Basically, I'm wondering if there is a way to pull in the complete contact information without it converting into a text field (so I can use it for dynamic contact list filtering and other features)?

The data in the formulas below are all email addresses (contact lists), but the output is always a name string/text.

=IFERROR(VLOOKUP([Sales Representative]@row, {Reference - Name & Email & Location - NEW Range 3}, 5, false), "Unassigned")

=INDEX({Reference - Name & Email & Location - NEW Range 2}, MATCH([Sales Representative]@row, {Reference - Name & Email & Location - NEW Range 4}, 0))

Find more posts tagged with

Accepted answers

Ipshita

@Noah Tamminga - try converting the column where you are getting your results/output as a "Contact List" column type and see if that makes a difference. I am assuming what that should do is, it should pick up the contact name and change it to email just by the reference of the name.

Hope this helps! Cheers!

All comments

Ipshita

Hope this helps! Cheers!

Ipshita

@Noah Tamminga - I am glad it worked!! :))

Cheers!

Noah Tamminga

@Ipshita - thank you so much! I'm starting to wonder how I got hung up on this in the first place with such an easy fix, but I really appreciate the solution.

Ipshita

@Noah Tamminga sometimes it happens to the best of us! Feel free to reach out, I am always happy to help:))

Cheers!

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.