View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
broderp broderp is offline
external usenet poster
 
Posts: 9
Default Looking up info from chart with multiple catagories How?

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