HI everyone. I have a dataset with comma separated values in two columns (B and C), the source and target language columns (see screenshot). I would want to do a lookup somehow, so that I can find anyone that has ENglish as a source language and Swedish as a target language. To give just one example. In column A I have the names (not shown here for privacy reasons), so I would want to get those names as the result. All names.
I've had two issue with different methods I tried:
- I either ended up with English as a source language result, only if it was the only language someone mastered. Not if they had multiple languages and English happened to be one of them.
- On another instance, I got the result, but it only showed me one.
But rather than fumbling around, there is maybe someone with an easy answer
Many thanks,
Yves
I've had two issue with different methods I tried:
- I either ended up with English as a source language result, only if it was the only language someone mastered. Not if they had multiple languages and English happened to be one of them.
- On another instance, I got the result, but it only showed me one.
But rather than fumbling around, there is maybe someone with an easy answer

Many thanks,
Yves