array lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top