INDIRECT function not working

Question

I've tried working out the examples given on several sites regarding the use of INDIRECT for dependent drop down lists. I've tried this simple example (just the first part of the Produce and the Vegetables (http://www.contextures.com/xlDataVal02.html), and I keep getting the error: "The Source currently evaluates to an error."

My intention is to validate data in a mailing list based on the country. So, if the user selects, say, USA, the validating data would be the list of all 50 states; if he selects UK, the resulting list would be all the counties in the UK, and so on.

I can't get it to work.

Does anyone have a solution? Thanks

Answer 1

So Debra's method works very well.  If it is not working for you, it would be an indication that you have not implemented it properly. 

at the link Vijay has pointed you to besides his solution which is similar to Debra's I believe, HanV cited three links to Debra's site:

http://www.contextures.com/xlDataVal02.html

http://www.contextures.com/xlDataVal13.html

http://www.contextures.com/xlDataVal15.html

the second two are other methods do have dependent dropdown lists

If you can't get it to work, you can click on my name (blue - hyperlink) and look at my profile.  It will have my email address and you can send me a copy of your workbook.  I can take a look and provide an example. 

Or you can post your workbook on a sharing site and post the link then anyone that is interested can take a look.

--

Regards,

Tom Ogilvy

Answer 2

You may refer to this thread link where I have given solution to a similar problem.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/insert-condition-in-data-validation-list/d343922f-10a7-47ac-9df5-48734d8323a2