Excel Vlookup Named Range

[monagan]

If anyone can point me to a good thread that I haven't foudn yet, or give me some kind of direction on this problem.

I have a parts table (excel)
Parts Number Description weight
0123l5 something 5
235j7 something else 6
075dfg and another 257

What I want is based on the an input from a user, have excel pull up all the parts numbers.

For instance if a user picks 4" Fan in a drop down box
I want the named range "FourInchFan" to appear in a table on the same worksheet.

I hope my description was well enough.

"And on the 8th Day, He recorded a macro

 

[SkipVought]

You can add a second criteria in the custom selection in the dropdown.

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]