I found contextures to be very confusing.

In short, I did some research on how to use the INDIRECT formula, and was able to solve for creating dependent dropdown lists. HTH