Match Formula Help

I have created two sheets and in need of some help with a formula.

Sheet 1: Vendor Directory (with columns "Vendor ID", "Vendor Pin", and "Vendor Verified").

Sheet 2: Vendor Verification (Which vendors will populate with their "Vendor ID" and "Vendor Pin")

When a row is entered in Sheet 2 the formula should look at sheet 1 to see if it matches with any "Vendor ID" and "Vendor Pin". If it does match, I need it noted as "Yes" under "Vendor Verified" on sheet 1.

Thank you in advance for your help!

Find more posts tagged with

Formulas

help

Accepted answers

AravindGP

Hi @Natalie11

In Sheet 2, have a column to combine the entered Vendor ID and Vendor Pin with the formula =[Vendor ID]@row + " " + [Vendor Pin]@row. Once done, in Sheet 1's Vendor Verified column have the formula =IF(INDEX(COLLECT({column reference of the new combination column of Vendor ID and Vendor Pin}, {Column reference of Vendor ID in Sheet 2}, [Vendor ID]@row), 1)=[Vendor ID]@row + " " + [Vendor Pin]@row, "Yes", "No")

All comments

AravindGP

Hi @Natalie11

Natalie11

@AravindGP Thank you so much!⭐️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.