Function to multiple ranges

  • Thread starter Thread starter Tomek
  • Start date Start date
T

Tomek

Which function may be used with multiple ranges?

Commonly used "lookups", "index" and "match" don't seem to work. Is there a
trick in multiple ranges?

Tomek Polak
 
Some functions work, others don't. INDEX has a 4th argument that allows you to specify the area
(which of the multiple ranges). The lookup and match functions require a single contiguous block
of cells.
 
Usefull remark - didn't know that. I have tried and realized INDEX works
for non-contingous areas in one worksheet, but not for a few worksheets.

Looks like old "if" must be back in work.

Tomek
 
Back
Top