Data Validation

[bsneils]

I have a table:

4 13.00
5 16.00
5 18.90
5 19.00
6 9.00
6 12.00
6 15.00
6 16.00
6 20.00
6 25.00
8 10.00
8 13.00
8 15.00
8 18.00
8 21.00
8 24.00
8 28.00
8 31.00
8 35.00
8 40.00
8 48.00
8 58.00
8 67.00

I want the first cell say A1 to be a drop down list of 4,5,6, and 8. I want the second list to be a drop down list of the subchoices, say if 5 is selected in A1, B1 has a drop down list of 16, 18.9, and 19. I have tried using a vlookup in the source box for the second list but have had no luck. Any help would be great.

Please don't tell me to go to the contextures website either. They don't tell you how to do it with numbers.

Thanks

 

[Von Pookie]

Perhaps Aladin's post here would help?
http://www.mrexcel.com/forum/showthread.php?p=126

Edit: To leave your columns as-is, you would just use a slightly different INDIRECT statement than Aladin shows. Since you can't use numbers as the range names, just throw a bit of text in there--for example, name all of them starting with "List" (so the numbers for 4 would be named range "List4", "List5" for 5, etc.). Then for your second list, you would use =INDIRECT("List"&A1)

 

[bsneils]

Thanks, got it figured out with your help.