I think I didn't explain myself good enough. I tried posting the same question on an excel forum but I didn't get an answer yet.
Get multiple answers depending on other text - Excel Help Forum
If you can see it, theres also an example of what I want to achieve.