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