Forum Discussion

YJ2023

Copper Contributor

Feb 21, 2023

EXCEL Getting exact match of 3 cells against anywhere in 3 columns

Hi All, I am new to the forum hope someone can help me with the correct formula for me, I al looking to get an "output" column created like below A B C E F G H output I am Leg...

excel

Formulas and Functions

FikturFox

Brass Contributor

Feb 21, 2023

YJ2023

Perhaps..

=LET(a, BYROW(A2:C6, LAMBDA(r, TEXTJOIN("|",1,r))),
BYROW(E2:G6, LAMBDA(r, IF(ISNUMBER(XMATCH(TEXTJOIN("|",1,r),a)),"Yes","No"))))

YJ2023
Copper Contributor
Feb 21, 2023
FikturFox I am getting a formula error - =LET(a, BYROW(A2:C6, LAMBDA(r, TEXTJOIN("|",1,r))),BYROW(E2:G6, LAMBDA(r, IF(ISNUMBER(XMATCH(TEXTJOIN("|",1,r),a)),"Yes","No")))) when I ran it
- FikturFox
  Brass Contributor
  Feb 21, 2023
  What does the error says? Is it a #Name Error? or what?
  - YJ2023
    Copper Contributor
    Feb 21, 2023
    FikturFox the error is