Pulling a name out of a columnq

I have a customer column on sheet 1 (ie. "John Doe") and a customer column on sheet two that displays there company name as well (ie. "SSS-John Doe")

On sheet one I am writing a formula to reference sheet two, so far I have =COUNTIF({PBR Customer}, FIND("John Doe", @cell) > 0)

This works but I want it to automatically pull out the name from the customer column on sheet one vs having to type it into the quotations.

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

You can use the column name in sheet1 at row,

=COUNTIF({PBR Customer}, FIND([Column Name in Sheet 1]@row, @cell) >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.