Have a look at Debra Dalgleish's site for help and examples of dependent
dropdowns using Data Validation.

http://www.contextures.on.ca/xlDataVal13.html#Depend


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 16:08:58 -0500, tiab86
wrote:


Here's the problem, in short....

I want to be able to look up a part number by first selecting a
Category, and then by a class from that List of Categories.

I can get the drop down box to work for the Category but when I try and
add the Class drop down boxit errors out.

I have found the formula, using Data Validation, below but I can't seem
to get it working.

=INDIRECT(VLOOKUP(A10,$BD$5:$BD$241,2))


Can Someone Please give me a hand.