Index and Match Not working

1. You are over complicating this.

I would not use index within VBA, what benifits does it give you?

Please Login or Register  to view this content.

is the same as

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Both my solutions will be a lot faster than using application.index



2. The Match function is usually used with a zero.

Please Login or Register  to view this content.

3. However Application.match is very slow consider using find,

Please Login or Register  to view this content.