Looking at all the posts about MATCH, it seems that its a triggy
feature. Mines results in an error, appearently because of its
limitations.

=IF(ISNUMBER(MATCH(C7,'Sheet C'!E:E,0)

I do have another range on the same sheet, namely

Z36 - Z40

What is the best and the fastest in terms of calculations:

Adding another MATCH with Z:Z or 36:40 or Z36:Z40

or

E1:Z40?

Bart

Z36:Z40 will be the quickest to calculate, as the formula will only
have to examine 5 cells - avoid using Z:Z as this is 65536 cells!

Hope this helps.

Pete

AA Arens wrote:

> Looking at all the posts about MATCH, it seems that its a triggy
> feature. Mines results in an error, appearently because of its
> limitations.
>
> =IF(ISNUMBER(MATCH(C7,'Sheet C'!E:E,0)
>
> I do have another range on the same sheet, namely
>
> Z36 - Z40
>
> What is the best and the fastest in terms of calculations:
>
> Adding another MATCH with Z:Z or 36:40 or Z36:Z40
>
> or
>
> E1:Z40?
>
> Bart