Lists on two levels

[mattbarb]

Im trying to have a the excel sheet pull in a list depending on what is selected in another list. The idea is to have a dropdown in D1 of two list depending on that value the information updates in D5 (roles).. Driving me nuts hope someone can understand what im trying to do and help. Fingers crossed.

Many thanks


Examples doc added here: https://we.tl/vHXwTnG0r1

 

[DRSteele]

Welcome to the forum.

This link demonstrates how to do that. http://www.contextures.com/xlDataVal02.html