Drop Down Boxes

[tiab86]

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.

 

[Biff]

Hi!

See this:

http://contextures.com/xlDataVal02.html

Biff

 

[Gord Dibben]

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