INDEX/MATCH within an Array

[xceej]

Hi
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?

 

[RoryA]

Cross-posted: INDEX/MATCH within Arrays

Please take a minute to re-read the forum rules on cross-posting and follow them in future. Thanks.

 

[xceej]

Cross-posted: INDEX/MATCH within Arrays

Please take a minute to re-read the forum rules on cross-posting and follow them in future. Thanks.

Apologies, I wasn't aware of the rules on this but will post links in the future where needed! Thanks.