I am trying to make a query formula that allows my employees to type in their
name and read their stats from several other files. I can't use VLOOKUP
because there are usually more than one line of data per person. See Example:

I want a function that will search through this list:

Jeff Corwin New York 3
April Bellingham Chicago 5
Jeff Corwin Chicago 4
Andrew Mulligan Dallas 6
Jeff Corwin Dallas 6

And return this data (if value entered in search cell is "Jeff Corwin"):

Jeff Corwin New York 3
Jeff Corwin Chicago 4
Jeff Corwin Dallas 6