Create List from a Table

  • Thread starter Thread starter Sunnyskies
  • Start date Start date
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
 
Use a macro tied to your down down to do
data>filter>autofilter>filter on your selection
 
Afternoon Don,

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

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

Similar Threads

MATCH, Vlookup whatever 3
Open Form based on Multiple Values from Query 2
Count how many occurrences 3
INDIRECT Formula 3
change the formula by changing contents of cell 4
Help to create a macro 2
Summarizing data 2
Autofiller Tool Help 3

Back
Top