G
Greg
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
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