Thread: Second data list based on value of first list

I have a list in column A. This list can have 5 entries in it (using data validation). Depending on what I select in column A I want to only show the subordinates to that 'topic" in a drop down list in column B.
Please see file attached.

how do I set up column b to only show the subordinates of the respectve topic in column A?

Very frustrated!!
Thanks

Hi,

I think this is what you are looking for. The webpage will walk you throug the steps of creacting dependent lists.

Good luck.

abousetta