I have two arrays. The second array is a lookup array for the first array and returns the row where there is a match.
=IFERROR(MATCH(B2:B9,A2:A9, 0),"")
Then the integers in this new array are used as the index for another new array whose values are the Index of the matching value in the lookup array separated by blank elements for indexes not referenced.
I fear that this is simple problem that I am overthinking. Thank you for your help.
Originally, I tried comparing the two arrays directly, but this obviously didn’t work because only elements in the same ROW() are compared. Then I tried creating a Boolean Array, but am not sure how to implement it to find the original element index in the lookup array.
>Solution :
change the places of the ranges:
=IFERROR(MATCH(A2:A9, B2:B9, 0),"")
