View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunnyskies Sunnyskies is offline
external usenet poster
 
Posts: 107
Default Create List from a Table

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