List box from another sheet with Criterias

P

poloxstar

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 o
only
Techs that can take video calls
Can anybody help me?
Thanks
 
Top