I have a list of Data as follows (commas indicate a new column)
Name, Region, Subject Area1, Subject Area 2, Subject Area 3

Under each of the Subject areas is a value (1-4) that indicates this persons
ability.
Is there a way that I can an automated list for each of the subject areas
that shows all individuals that are above a certain level (ie 3-4):
Subject Area 2:
Name, Region, 4
Name, Region. 4
Name, Region, 3

Vlookup can only return the first individual.
Thank you for any help you can give!