Hi All,

I have a worksheet that contains 3 seperate lookup columns. My
challenge is that I need a low overhead way to find and count the
combination of true lookups. So if one of the 3 looksup is found I
would get a return of '1', if 2 of the 3 are found then '2'. I know I
can do this with an array formula, but am worried about the
calculation hit as this is a very complex worksheet and already has a
long intitial calc time.

I suppose I could do the inverse and could an 'iserror' condition and
then subract that answere from 3.

I thought of using a complex 'if' statment, but the logic seemed like
it would be too complex.

Any suggestions or am I stuck with an array formula? If so could
someone suggest a sytax to start with.

Thanks,

Greg

Please disregard. I found a solution, plus my data layout was so
complex that it would have taken a much deeper explanation to get good
feedback.

Cheers,

Greg