pull information if columns match

BrigitteM

Hi smartsheet community!

I would like to pull a value into a sheet from another sheet if the email address matches

sheet 1: source sheet

if 'email address' on sheet 1 matches 'created by' on sheet 2, I would like to pull the field 'Name' into sheet 2

=IF({2024 L&D Budget Source Range 1} = [Created By]@row, {2024 L&D Budget Source Range 2})

I tried above formula and it returned invalid operation

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@BrigitteM

In Sheet 2.

=INDEX({Name ref}, MATCH([Created By]@row, {Email ref}, 0))

Mark.poole

@BrigitteM

Or you could just copy and paste this based on the references you posted.

=Index({2024 L&D Budget Source Range 1}, Match([Created By]@row, {2024 L&D Budget Source Range 2}, 0))

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.