Look at VLookUp. It's default mode is a range test. But you'll need to
swap columns B and C. VLookUp does its test in the left column  of the area
it's checking.

You could also use SumProduct, but I think VLookUp is good enough for this.