|
|
|
|
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
|