I am in need of assistance.

I have no clue what formula to use to capture this data.

Sheet1
Video
Select Drop Down

Sheet2
Techs SkillSet
3456 2b-Can take video
5678 2c-can take video
7777 3c-can video

What formula should I use if I wanted to obtain a dropdown list of onl
Techs that can take video calls

Can anybody help me?
Thanks

--
Message posted from http://www.ExcelForum.com