I have 3 lists defined in worksheet 2, lists A, B, C. In worksheet 1, the
cells in column A will equal either A, B, or C. I want the dropdown list in
column 2 to be conditional of the value in column 1.

column a column b
A List A
C List C
A List A
B List B

etc...

I'm having a lot of trouble figuring this one out. Any ideas or help?