How do I use the same drop down list for 3 conditions using dependent data validation?

[juberpaul]

Hi,

I am still interested to know if there is a way to use 3 references for dependent data validation. Anyway, here are my predicaments:

1. I have 3 out of 10 categories that need dependent validation. For example, Present, Half-Day VL, Half-Day SL, Off, Holida, etc.
3. I need Present, Half-Day SL, and Half-Day VL to have the same drop-down.

Please help.