Dynamic Named Ranges and Indirect Data validation INCOMPATIBLE?

That thread is very old and since then I have come a long way in terms of being able to to have dynamic named ranges and dependent drop downs. If you post a workbook so I can see your raw data and your DV lists, it may be more evident what you're trying to accomplish.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Yes, your layout is perfect for this new technique I use. This layout allow unlimited dependent drop downs. All you need to do is create the lists on the LISTS sheet as shown. Each list name is in row 1, and the options that appear for the indirect drop down are listed below.

The only named ranges in use are

1) Cell A1 on the LISTS sheet is name "MAIN" to serve as the anchor for all the dynamic drop downs that will find and create themselves.
2) The MainList is a dynamic list of all the options you put in column A. THis is used to drive the first drop down on the Selection sheet.
3) The named range AllLists is merely all of row1 on the LISTS sheet. This is used to FIND any list offsetting from the MAIN cell, then that column is dynamically assessed to display all the options you've entered in that column.

The real magic in the DV formula found in cell B2 on the Selection sheet. That formula is doing ALL the heavy lifting. It looks at the choice made in the cell to the left (A2) and finds that value in row1 of LISTS, then displays all the items in that column. This can be used to make an infinite number of dependent drops downs.

B2 was copied to C2 and now C2 does the same thing, shows a list based on what was selected in B2.

First of all thank you very much for your time.

I am not able to understand what exactly you are trying to make me understand.

Ok.Now i need to name A1 as "Main"
Row 1 as "AllLists"

Please look at the file..Is my approach right in creating the lists as told by you.

I am confused. Pls do not mind me .

With this how what should be the DV formula in F22, G22 and H 22. Am stuck here.

Regards
Chand

You need to open the workbook I uploaded and look at the LISTS page. There are more columns added, all of the lists are on that page now, take a look.

The drop downs need to be moved a separate page, again, look at the version I uploaded.

Dear, Am not able to download the file. Please upload again.

Sorry for the inconvenience..

Thanks.

Can you see it on this message?

Thank you very much..