Another MATCH of combining with two MATCH functions?

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
List 6-of-36 combinations matching 4 (errata) 1
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
Return Value from cells which match criteria (complex) 2
Finding two variables on the same row to match function 2
File Size Problem 1
File Size a real problem! 3
Excel Solved - Using Excel 2007 Large()/Small() function without duplicate values! 1

Top