I have a question on creating a drop-down menu in the cell that would check
the contents of the other cell first, then based on what it finds there, it
will display the appropriate list in the drop-down. I am able to do this
using nested IF formula. However, nesting levels limitation in Excel 07 is
64, I have about 71 lists to display based on the contents of that other cell.

I tried vlookup with arrays, but Data Validation interface does not allow
using arrays.

Is there any other way?

Thank you!