0

I have a large report that I am pulling into a multi-dimensional array. I'm then using a function to remove dupes and then running various loops summarizing the data from the main array, but I am stuck on one point. I can't find a way to use INDEX/MATCH functions within arrays.

ie if I was simply using the report on the sheet I would use INDEX/MATCH to lookup column K and return the value in column G.

Can anyone please help?

Improve this question
8
  • 1
    Just loop the array, it will not be as quick, but also not that slow. Commented Jun 16, 2020 at 14:55
  • I was hoping to avoid loops as I'm already running numerous loops and it's already within 1 very large loop, so anywhere I can save time is a benefit, but maybe there's no other easy way.... Commented Jun 16, 2020 at 14:59
  • Looping is the way to go... for starters, MATCH is slower when used against an array than when used against a cell range... and INDEX/MATCH doesn't make sense when using arrays. Commented Jun 16, 2020 at 15:00
  • 1
    You would need to pull the column to use in the Match out of the 2d array and make it a 1d array. That itself is slow. Commented Jun 16, 2020 at 15:01
  • 1
    stackoverflow.com/questions/7031416/… but performance is very bad. Commented Jun 16, 2020 at 15:14
Related questions
1
Excel - VBA : deal with elements of an array when looking for matches
2
Excel VBA: Replicating Index(Match()) between several arrays
1
Return an Array of Indexes for Matching Values in a Primary Array
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.