A
AA Arens
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
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