I'm using an index match formula and I would like to make the match location the active cell. I can retrieve the value of the cell and I can retrieve the address of the cell but I want to make the cell active so that I can perform another function. I want to copy a range of cells next to the matched location. The Index formula appears to only allow one value to be returned at a time. I would like to return a range of values from the array.

These are the formulas I'm using:

=INDEX(I38:L42,MATCH(G38,I38:I42,0),2)

=CELL("address",INDEX(I38:I42,MATCH(G38,I38:I42,0)))

Any thoughts on how to make the match location active would be appreciated or if there's a better idea way to do this, I'd love to hear it.

Thanks in advance for your advice.

Mike