Excel formula to compare multiple matches

[MFT]

Excel formula for multiple matches. Kindly help to find a formula in G3 and G4. I have data in column B and C, I wanted to match it with column E and F. However vlookup does not work as there are multiple matches. I wanted a result of True/False if B and C contains the values in E and F.

Project code	BS		Project Code	Project Business Stream	Result
3702​	AAAA		3999​	AAAA	TRUE​
3875​	BBBB		3999​	DDDD	FALSE​
3961​	CCCC
3999​	CCCC
3999​	AAAA		In cell G3
3999​	BBBB		I wanted a result here if B column contains 3999 with AAAA also present, then True
4271​	DDDD		In cell G4
4291​	AAAA		I wanted a result here if B column contains 3999 with DDDD is not present, then False
4307​	BBBB
3999​	CCCC
4400​	CCCC
4403​	BBBB
4403​	DDDD
4403​	AAAA
4403​	AAAA

 

[Peter_SSs]

Try this formula in G3 and copy it down to G4

=COUNTIFS(B$3:B$17,E3,C$3:C$17,F3)>0

 

[MFT]

Try this formula in G3 and copy it down to G4

=COUNTIFS(B$3:B$17,E3,C$3:C$17,F3)>0

Amazing Peter !! This is working exactly with my requirement. Many thanks

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

BTW, Welcome to the MrExcel board!

 

[MFT]

You're welcome. Thanks for the follow-up.

BTW, Welcome to the MrExcel board!

Thanks for the warm welcome. Really enjoyed

 

[abuahad]

Try this formula in G3 and copy it down to G4

=COUNTIFS(B$3:B$17,E3,C$3:C$17,F3)>0

Amazing!! I used to use an extra column.