array lookup

D

danatureboy

I have wasted hours searching through microsoft help files trying to find a solution

I have 9 seperate arrays. depending on what I input (1-9), I want excel to return the whole array of the respective input number. The closest I have gotten is the 'INDEX' function and I do not know how to write macros to complete. Do you know a function that will return an entire array?
 
A

Alan Beban

danatureboy said:
I have wasted hours searching through microsoft help files trying to find a solution!

I have 9 seperate arrays. depending on what I input (1-9), I want excel to return the whole array of the respective input number. The closest I have gotten is the 'INDEX' function and I do not know how to write macros to complete. Do you know a function that will return an entire array?
Click to expand...
An Excel array? A VBA array? A range of cell values? Something else?
What is meant by "the whole array of the respective input number"? I.e.,
what input?

Alan Beban
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX return multiple columns 1
returning an entire array of values 9
Match Array returning #NA, Works individually 4
Need help finding a substring in a array of strings. 1
Array-friendly functions 1
Reverse a function to return the array? 4
Compressing multiple functions across an array into one cell 6
Vlookup array formula problem 2

Top