Vlookup help with multiple results

[Gerd]

I have a range of cells which has a master list of my inventory. Headers are
Category, Vendor, Item, Price. This list is in Sheet 1. I have 12 different
categories of inventory. What I want to do is: On Sheet 2 I have entered a
Vlookup of one of the twelve categories. My problem is that I only get the
first row of data. How can I get all the subsequent rows of this same
category onto Sheet 2.

Thank you in advance

Gerd

 

[Gary''s Student]

use AutoFilter and copy rather than VLOOKUP()

 

[Gerd]

Thanks a lot. That works great.

use AutoFilter and copy rather than VLOOKUP()