Vlookup

[rxpotlu]

Hi All,

Can you help me with below please? 

company	Platform
abc co	123
abc co	456
xyz co	123
xyz co	456
yyy co	456

i made up above data since i cannot share my actual data. i am looking to filter out company names with 456 platform only. for example, abc co has both 123 and 456 so i want a false value next to it. where as i want true value for yyy

[#2 · Accepted solution]

@rxpotlu 

=LET(A,A2:A10,
e,UNIQUE(A),
ok,COUNTIFS(A,e,$B$2:$B$10,456),
company,COUNTIF(A,e),
result,FILTER(e,ok=company),
result)

Is this what you want to do? 

If you don't work with Office365 or 2021 you can try this formula:

=NOT(COUNTIFS($A$2:$A$14,A2,$B$2:$B$14,456)<COUNTIF($A$2:$A$14,A2))

[#3]

Thank you so much. the second formula worked. but what if i want to look for two values.

company Platform
abc co 123
abc co 456
abc co 789
xyz co 123
xyz co 456
yyy co 456
uuu co 789

as in, what if i want both 456 and 789

[#4]

@rxpotlu 

=NOT(SUM(COUNTIFS($A$2:$A$12,A2,$B$2:$B$12,{456,789}))<COUNTIF($A$2:$A$12,A2))

Is this what you want to do? Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.