Extracting Continuous Data

I'm curious if there is any way to extract a range of data and output it, in order, automatically using a formula, using constraints on what is extracted. Apologies if I'm being a little vague or confusing.

Basically, if I have a column of data:

Black
White
Red
Purple
Green
Blue
Yellow
Fushia
Aqua

and a user types "2-4" in an input field, can I extract "White; Red; Purple" and output it as a second column? Would it be possible to also get a similar result if a user were to type "2-4, 7-8" (which would output "White; Red; Purple; Yellow; Fushia")? I would like to have something of this nature integrated into an excel spreadsheet, which will eventually be put onto Google Docs, so VBM and other excel-specific programming is more or less out of the question.

@KingOfZeal

I'm sure there is probably a better way to do this but here is my shot at it. I just attached a number to each value and said that if the number falls within the range that you declare that it should repeat it in the next column otherwise leave it blank. Hope that helps!

The problem with this solution is that it wouldn't be able to parse multiple selections: IE, if I wanted to select "2-3" and "5-6", I'd need to handle each possibility separately within the same formula, and there's no way to know how many ranges would be looked up. I gave an extremely truncated example of what I would need - it would have to be able to pull from a list of at least 500+ rows, with possibilities of 10+ different ranges being requested simultaneously.

The ultimate goal of what I'm doing is building a 'drill down' feature to be linked with an accounting journal. I want to be able to type an account name in a field and return all the things that happened to that account, so you wouldn't have to hunt through the entire journal. I'm at the point where I can pull the locations of those items, but I'm trying to find out how I can easily reference them within an excel formula. The "2-3" aren't user inputs per se, but generated at each line automatically to tell the location of the details I need. As such, they CAN be manipulated into any format (IE, usable within an INDIRECT if needed).

Your format could work, but would require multiple look-ups and cross-referencing the results, and so a fair bit more work than I'm willing to put in at this point. However, if no other solution arises, it's still possible to use.