Libertineash
New Member
- Joined
- Jun 4, 2010
- Messages
- 27
I'm trying to build a spreadsheet that returns values from a data tab dependent on what options the user has picked on the main tab using list boxes. My list boxes return 3 numbers which i have concatenated and assigned to the relevant row on my data tab.
However, there are instances where the 3 options chosen return more than one value.
Is there a way to use a lookup or another function on the main tab to return all available results???
For example, 923 appears 4 times, I would like to have the 4 results shown on the main tab.
However, there are instances where the 3 options chosen return more than one value.
Is there a way to use a lookup or another function on the main tab to return all available results???
For example, 923 appears 4 times, I would like to have the 4 results shown on the main tab.