Here's a sample file:

sample extract.xls 15.5kb

http://cjoint.com/?mhuswKfgeU

The formula (cells in yellow) are array formulas. Select a formula cell and
look in the formula bar. You'll notice the formula is enclosed in squiggly
braces { }. Array formulas are entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). When done properly Excel will place the
braces around the formula. You cannot just type these braces in. Anytime you
edit these types of formulas you MUST re-enter them as arrays using the key
combo.

Biff

"broderp" wrote in message
...
Thanks for the help.
I would like to input Model, Voltage, and Phase. Sorry for the confusion.

The end result is I'd like the information from all categories to be
shown.
I'm not sure how to organize the data or what formula(s) I will need to do
this as easily as possible.

Please keep in mind, and table or range would have multiple models numbers
and voltages, the example I gave was for model'x', there are about 75
other
models with thier own chart. The end result is I'm looking to find the
'fuse' part number based on the 3 input criteria.

regards
Raymond

"T. Valko" wrote:

I'd like to be able to select MODEL, HP and PHASE
(IE 'model x', 230v, 3 PH)

But your example shows model, volts and phase.

This isn't too difficult but figure out what crteria you want to base the
lookup on and we'll get you up and running!

Biff