Worksheet Formula: Find value in an array

I've got a question about finding a value in an array. The following Table is called CustomerSubscription.

I need to be able to tell, based on a CustomerID, whether he/she still has an active subscription. If yes,
the value should be true, if not then it should obviously be false.

For example, customer 1 has an active subscription - whereas customer 2 has none.

What is the best way to solve this problem. I have no problems if each customer only has one subscription,
but I'm unfamiliar on how to do this with arrays - that's what I have to use, right?

I've attached the worksheet to this post.
forum.ozgrid.com/index.php?attachment/66523/

Thanks for your help.

Massimo

Re: Worksheet Formula: Find value in an array

I did indeed forget to mention where the result should be. Apologies for that.

I just want to be able to check whether a customer has (from the many subscriptions)
at least an active one. The result should be in B14, B15, B16 I hope that it's a bit clearer now.

Re: Worksheet Formula: Find value in an array

Oh it's so easy! Thanks for the formula.
And now I've learned something new.

Thanks