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.