Is there a way to use some combination of index/match/lookup functions to be able to return a list of values instead of just one cell? I'm trying to create a spreadsheet that allows the user to program a sequence of equipment operations. The way the logic works, there are several lists of equipment operation orders. The lists can be called A, B, C, D, etc. Each list will have a list of equipment operations that can be changed in another part of the spreadsheet and won't be in numerical order. For example, list A might be: Pump 3, Pump 1, Pump 5, Pump 4. You can choose to run different sequences of lists so for example, I might program it to run List B, List A, List C. I have the spreadsheet setup so that it shows a table of what order of equipment operations have been selected for each list. Row 1 is the name of each list: A, B, C, D, etc. Column A shows all the equipment operations on list A, Column B shows list B, etc.
I'd like to create another table where you can type in the name of the list in the first column and the list of equipment operations fills in automatically beside it (horizontally). That way, the user could type in their desired list sequence in the first column and see the complete equipment operation list that results.
For example:
Column A would be where the desired lists are entered.
A1: List (Header)
A2: B
A3: A
A4: C
Columns B-E would show the list of equipment operations associated with each list. Cell B3 would show Pump 3, C3 would be Pump 1, D3 would be Pump 5, E3 would be Pump 4. And so on, and so forth.
This simplified example is attached. How do I set up a lookup/match/index function to return all the values for each list? I don't even know where to start since usually these functions only return one value.
Any help would be greatly appreciated!
Bookmarks