Hi guys and girls

My first post of many no doubt

I have just got my first IPad and am shocked by some of the features missing compared to the full desktop version of excel such as multi layered sorting...

Anyway,
I have a list of 16 names, each will either be 'group a' or 'group b'
On a separate sheet I need to list these names in their groups. Now a Vlookup works but only returns one value. I need all 8 names in each group to be listed

Hope this makes sense
image.jpeg
image.jpeg