Forum Discussion
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...
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"))))
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
- What does the error says? Is it a #Name Error? or what?
Check your formula again. You might be missing something. What excel version are you using?
Here's another approach with helper column if you are not using M365.
In helper column:
=A2&"|"&B2&"|"&C2
**fill down
In results column:
=IF(ISNUMBER(MATCH(E2&"|"&F2&"|"&G2,$J$2:$J$6,0)),"Yes","No")
--fill down