LookUP function help with IF function

[HarryC]

Hello
Please help me here.
I am trying to create a formula where i have column B with data validation (low, medium, high and very high). See example below

Column A column B
1 Product1 High
2 Product2 Low
3 Product3 Very High
4 Critical rating

I want to create a formula on cell B4 to give me result if any of the cells between B1 and B3 has either high or Very High, it should return result with a Yes.

Thanks

[JohnTopley]

Try

=IF(SUM(COUNTIF(B1:B3,{"High","Very High"})),"yes","no")