Hello,
I have several workbooks that share the same data for data validation. I
have been success with just about all of the shared data. I am hitting a
snag with just one important datavalidation list. This is a dependent list.
The list from column B depends on what was entered in column A. I have
linked all of the data name fields/lists, but it still won't work. In my
validation for coulmn B, I have the source as:
=INDIRECT(VLOOKUP(A1,DeptLookUp,2,0))

What should I be doing differently? I have read everything on Contextures,
but there is nothing about this particular situation.... help please..
thank you,