Create List from a Table

S

Sunnyskies

Example
On another Sheet:
A B
BEM 06T19
BFN 09S09
BEM 03R02
KIM 96R01

Now on another sheet I want a table that if I select BEM from a drop down
(B2), it will show me 06T19 and 03R02 in cells B5 and B6 respectively.

Thanks
 
D

Don Guillett

Use a macro tied to your down down to do
data>filter>autofilter>filter on your selection
 
S

Sunnyskies

Afternoon Don,

Trying to stay away from Macros. Is there not a formula that will produce
the same result?
 
Top