VLookup Query

Afternoon all,

I am trying to use vlookup to return two rows in the attached example. Basically when I select Area A and Team 1 in the Selection I want to return the two rows answers (Alice, Chris), in two separate cells (D11 & D12). At the moment I am only able to return the first row answer (Alice)

This is a simplified example of something bigger I want to use it for. If anyone can tell me how to do this or suggest another way of returning these two values, in two separate cells that would be great

Thanks

senan_g