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.


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=391446

Hi!

See this:

http://contextures.com/xlDataVal02.html

Biff

"tiab86" wrote in
message ...

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.


--
tiab86
------------------------------------------------------------------------
tiab86's Profile:
http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=391446

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.