vlookup to search mulitple criteria and return the entire rows data
I am creating a couple of documents. Firstly a summary of all data for the whole business based on an agents quality. There will be headings such as name, team, date, etc on the Summary sheet. I am looking to then from a separate target sheet (individual Agent) to search the summary sheet using vlookup to search multiple criteria (name and date) to then pull that whole row of information across to the target sheet. I've search and attempted multiple formula's but am unable to get 1 to work. Has anyone any ideas for an excel novice please. Thanks.
