Lookup A Value and Populate Cells

J

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 A1:D2, 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top