I've been working on this one for a while, but I can't seem to wrap my head around it. I'd love some help.

I currently have a spreadhseet that reads something like this.

Dell Akron 27 Sunday
HP Akron 26 Friday
Canon Canton 24 Sunday
Toshiba Cleveland 21 Monday
Compaq Dayton 20 Wednesday

Essentially, what I want to be able to do is create another sheet with just the rows involving Akron. When I use vlookup, I can only pull the first dat point it comes to. How can I type in a formula to pull all of the data associated with Akron into a separate sheet?

Any suggestions?