Hi, hope you are all looking forward to the weekend.

Am trying to use Vlookup (which may be wrong) to solve an issue I have.

IN sheet1 I have a list of tasks in column A, some other values in B to D and then people's names in column E for who is responsible for that task. People have various tasks assigned to them.

In Sheet 2 I have chosen one of the people's names and want to automatically pull in all the tasks assigned to their name. So sheet 2 should display:

A1 Simon
B1 Do homework
A2 Simon
B2 Go home

How can I do this especially as the tasks are plenty with various different people against them and it needs to just pull in row after row the ones relevant to that person?

Thanks so much

Simon