Hi, simple question:
I have this working function:
=INDEX((A1:C6, A8:C11), 2, 2, 2)
Now, what I want to do is the following:
I want the INDEX function to get the referenced arrays from another cell i.e.:
this:
=INDEX((A1:C6, A8:C11), 2, 2, 2)
shall be contained in another cell, so that I can add more arrays later on without having to change the INDEX function itself.
I tried:
=INDEX((A12), 2, 2, 2)
with (A1:C6, A8:C11) as content of A12.
Any help appreciated
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Sounds like you want to apply an INDIRECT expression, such as a12=a1:c6, a13=A8:C11, and your formula runs as:
=INDEX((INDIRECT(A12), INDIRECT(A13)), 2, 2, 2)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
that did the trick, many thanks! : )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks