VBA:: intersect vs. match method

Question

I had a question pertaining to the two built in VBA function of .Match and .Intersect. Currently I have 2 1-dimensional arrays that I wish to consolidate information into a new array. I realize I've posted a question about the approach to the problem earlier but this question pertains to which method would be better. Would one way be able to consolidate information into a new array faster than the other? and is one method more reliable than the other as well?

Answer 1

From Excel help

Excel Developer Reference

Application.Intersect Method
Returns a Range object that represents the rectangular intersection of two or more ranges.

Arrays are not ranges, so interset is not applicable to your question as stated.

A more detailed explanation of what you are trying to do, and what form your raw data is in will allow better advice