Using 2 references for vlookup

[jdhfch]

Hi,

Please can someone help?

I am trying to create a list from a master list based on a criteria. Below is an example

https://www.dropbox.com/s/ui61g35ycc7em0u/Screernshot.jpg?dl=0

Basically, I want to create a list from the master list in row A & B

I want to use the account manager name in cell D3 (John in this instance) and pull all instances of John from row A, then all instances of Johns customers as well in row B. I want there to be no spaces.

Many thanks

Jason

 

[jdhfch]

Sorry... the title is incorrect. it should read create a list from a master.. I can't edit it!

 

[steve the fish]

Id definitely be using a pivot table for that.