have two lists that I want to link. See the image here http://tinypic.com/view.php?pic=5y4z9f&s=9#.WWeZixXyuM9
I want to populate one drop down list (in a cell) with values from the column on the left (Access Control and Building Fabric). I want a second drop down list in a cell populated with values in the column on the right. When Access Control is selected from the first drop down the contents of the second drop down must change to the contents of what is directly across from it in the pic.
When Building Fabric is selected I want the drop down to change and those corresponding values to appear in it.
Can anyone help me to do this? I have to use VLookup, I know that much. I haven't been able to find a similar example online.
Bookmarks