Match Formula Help

Natalie11

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!

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")

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")

Natalie11

@AravindGP Thank you so much!⭐️