No sound, just a sample for a specific person. Dependant dropdown data validation Formula In Second Column =INDIRECT(SUBSTITUTE(Q3," ","_")) Workbook in Sample. https://drive.google.com/file/d/1f3_korf-KEaHLBC45lPKpZsw3f0G95wh/view?usp=sharing
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.
