VBA code to reset dependent dropdown

[Donutderek]

Hello,

I've got a workbook I've been working on with primary drop-downs located in col G, cells 13, 14, 15,(merged cell with H&I), my dependent drop-down is in C of the same rows. (Merged cell with D). Despite trying codes copied from forums here and adjusting the locations to my situation, I can't seem to get it to work when I test it. I'm trying to get the dependent drop to reset when my primary value has been changed. Nothing I've tried seems to work.

 

[Fluff]

You're welcome & thanks for the feedback

 

[Donutderek]

Just when I think I'm wrapping my head around this, I'm at a loss again here.
Using VLOOKUP, is it possible to have it search multiple variables (locations) of data for the proper coinciding data to autofill? For example, I got it to work for just one of my dropdown selections, but the formula only allows me to put in one reference point. If say, dropdown value A is selected, my VLOOKUP will go to "x" sheet and plug in the appropriate data. If dropdown value B is selected it won't search another sheet.
Is there an ( ) SUBSTITUTE/IF/INDEX formula to add to VLOOKUP that will let me tell it to choose another area based on the selection?

 

[Fluff]

As this is a totally different question, you will need to start a new thread.

 

[Donutderek]

Ah, yes. Thank you.