title: Create filtered drop down list based on value
body: <p>Looking to create a filtered drop down list based on a value.</p>
  <p>Ex. <a href="https://i.stack.imgur.com/1PdKF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1PdKF.png" alt="enter image description here" /></a></p>
  <p>I would want to get only the Name column values where the Group column equals 'CURRENCY' into a dynamic drop down list. More values would be added so the source data would be dynamic as well. I've tried vlookup but would need to look backwards to get the name values which wasn't working out. Any help would be greatly appreciated!</p>