Forum Discussion
Solved
Working with Arrays
There may well be a simple solution to this, but I've search far and wide and can't find how Excel can achieve this outcome. I have an array of numbers stored in A1:G10. I'm trying to retrieve the ...
Rod_Sims The basic formula would look like this:
=INDEX(A1:G10,3,4)where you can replace the 3 and 4 with references to cells that contain these numbers.
Rod_Sims The basic formula would look like this:
=INDEX(A1:G10,3,4)where you can replace the 3 and 4 with references to cells that contain these numbers.
For your amusement, something I occasionally do is to wrap the INDEX function within a Lambda function to create a more conventional programming syntax
Worksheet formulae = MyArray(3,4) = MyArray(3, ) = MyArray( ,4) = MyArray( ) MyArray = LAMBDA([r], [c], INDEX(Sheet1!$A$1:$G$10, r, c) );Thank you so much - an elegant and simple solution to what I had thought might be more complex. I've got my formulas working. Again, thank you!
