Lookup A Value and Populate Cells

[Jeff]

I would like to be able to lookup a value, and based on that value,
populate cells where that value exists. For example:

Class# Vehicle# Dept# Status
1234 1111 2222 A
1234 1112 3333 O
3456 1113 2222 X
8787 1114 2222 A
8787 1115 3333 A
8787 1116 4444 O

I would like to lookup each class and return all the information for
that class: Class#, Vehicle#, Dept#, and Status, which will be placed
into another sheet. For example, class 1234 and the it's related data
will be placed in cells A12, class 3456 will be placed in cells
E1:H1, and class 8787 will be placed in cells I1:L3.

I tried using Vlookup, but it seems to only return the last instance
of the value I am looking up.
Thank you in advance for any help you can provide,
Jeff

 

[Ken Wright]

Try here for that:-

http://www.contextures.com/xladvfilter01.html#ExtractWs