If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Indirect function help
Please help - I followed the directions at the site below to set up data
validation where the second list is based on the selection of the first list. The first list works fine but the second list doens't have anything in the dropdown, even though there are items on the list. The name box for the dependent list matches one of the items on the first list. For the dependent list, the data validation is set to List with the Source as =INDIRECT(A2). I set all of column A with data validation for the 1st list and all of column B for the second list. What other information do you need to help me figure out where I went wrong? http://www.contextures.com/xlDataVal02.html Thank you, Jim |
#2
|
|||
|
|||
Indirect function help
Hmm...
First, I'd make sure there aren't any extra spaces anywhere causing an error. Second, I'd goto Insert - Name - Define, and then click on the named ranges, first the independent, and then the dependent (whatever is listed in A2) Make sure they are referring to the correct things. You might also check to make sure your have absolut reference (the little $ symbol) in the correct spots. -- Best Regards, Luke M "Jim" wrote in message ... Please help - I followed the directions at the site below to set up data validation where the second list is based on the selection of the first list. The first list works fine but the second list doens't have anything in the dropdown, even though there are items on the list. The name box for the dependent list matches one of the items on the first list. For the dependent list, the data validation is set to List with the Source as =INDIRECT(A2). I set all of column A with data validation for the 1st list and all of column B for the second list. What other information do you need to help me figure out where I went wrong? http://www.contextures.com/xlDataVal02.html Thank you, Jim |
#3
|
|||
|
|||
Indirect function help
I got this to work by just setting up row 2 and then dragging it down...
"Jim" wrote: Please help - I followed the directions at the site below to set up data validation where the second list is based on the selection of the first list. The first list works fine but the second list doens't have anything in the dropdown, even though there are items on the list. The name box for the dependent list matches one of the items on the first list. For the dependent list, the data validation is set to List with the Source as =INDIRECT(A2). I set all of column A with data validation for the 1st list and all of column B for the second list. What other information do you need to help me figure out where I went wrong? http://www.contextures.com/xlDataVal02.html Thank you, Jim |
Thread Tools | |
Display Modes | |
|
|