[SOLVED] Validation problem with reading Lists

Hi,
I have be having the same problem as here http://www.excelforum.com/excel-gene...-selected.html I used some of the attached files (thanks), but, I cannot seem to get it working. The "List1" is Name in the table on sheet4, then there is the helper and list 2. On Main sheet I have the drop down list selection process. However List2 always seems to read the same, and I cannot seems to access the defined List2 in sheet4 from the validation data in the drop down list in the main sheet (not sure weather this is the problem) Any help would be greatly appreciated.

Thank you

Scott

Hi,

I can see no validation drop down in the Main sheet. Please clarify.

Originally Posted by scottpattison

Hope this clarifies..

Scott

Sorry, but in my case it doesn't.

Can you manually add some typical results and explain how you arrive at them. And please explain what column Q on Sheet4 is meant to be doing. I can't help thinking this is all more complex than it needs to be. Neither am I sure what you mean by 'not leave a blank gap'.

Are we talking dependent drop down lists here where the choices available in one drop down are dependent on a choice made in a prior drop down list?

See if this amended workbook is easier to understand

The Names are all dynamic.
But the formula in the helper must be extended as your validation range increases, this could also be dynamic.

Formula:

Please Login or Register  to view this content.

The formulae in H3 is an array and must be confirmed with Ctrl+Shift+Enter not just Enter before dragging down

Formula:

Please Login or Register  to view this content.

Here's an update to your particular file. I've taken the opportunity to simplify the List2 formulae.
Please note that these are array formulae and need to be entered with Ctrl Shift and Enter. I think these had been entered as a regular formulae in your original file.

Thanks for the feedback Scott.

pip pip.