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...
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
