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![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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