Hello.Im pretty basic at excel, and i could not find a solution for my idea - Sound Techical Rider table

Idea:
I have for example 32 inputs in my sound mixer, and before every concert I write down all microphones i will use, stand types, grouping, etc.
60% of concerts - table contents doesnt change a lot - for Bass drum there always be 1 specific mic and short stand, but there are mics/instruments where i need to choose - here comes the data validation, but for now i havent find a way, to ''paste'' data validation to other cell

Here are some details+example

Ch. Description Mic/DI Stand Group
1 BD D112 Short Drums
2 SNARE d40 clip or short Drums
3 TOM1 D40 clip or short Drums
4 FL TOM D40 clip or short Drums
5 OH L C430 or C1000 Boom Drums
6 OH R C430 or C1000 Boom Drums
7 Bass DI or Line - Bass
8 KEY L AR133 or dB10 - Keys
9 KEY R AR133 or dB10 - Keys
10 VOCAL D5 or D5w or KM4 boom or Base Vocals

I want situation - Writing down B2 - BD(bass drum) - excel autofills Mic, stand, and group
and if i write VOCAL or Vocal 1 ,2, etc. - mic/DI collumn gives a drop down menu, also dropdown menu for stand type, and chooses group.

Can anyone help with this? Still no big progress with LOOKUP funtion and IF variations.INPUT example.xlsx