pico
11-07-2006, 07:18 AM
Hi guys,
I have a question regarding vlookup or hlookup or whatever function excel could use to solve my problem. I have a userform in sheet1 where control toolbar checkbox(ex:softstart checkbox) is updated. I also have two cells in sheet 1 namely for voltage and Horsepower rating. something like this--->
Softstart (checkbox)
Motor-(HP cell, Voltage cell)
If the softstart checkbox is selected and the motor horsepower and voltage ratings are selected output partnumber for the items. The table required is stored in sheet 2 and it looks like this.
Voltage HP
15 20 25 30 35 40
208 P# P# P# P# P# P#
230 P# P# P# P# P# P#
460 P# P# P# P# P# P#
I cant type the table correctly on the forum ...hopefully people get the idea. The voltage column contains 208 , 230 and 460 on the left...the Hp colum is horizontal 15,20,25,30...based on the voltage and horsepower select the partnumber.
I would like the code to ouput the specific partnumbers for the softstarter according to the voltage and hp supplied on sheet 1. Is this possible using excel?...Any help would be greatly appreciated. Thanks. Btw this site rocks!
I have a question regarding vlookup or hlookup or whatever function excel could use to solve my problem. I have a userform in sheet1 where control toolbar checkbox(ex:softstart checkbox) is updated. I also have two cells in sheet 1 namely for voltage and Horsepower rating. something like this--->
Softstart (checkbox)
Motor-(HP cell, Voltage cell)
If the softstart checkbox is selected and the motor horsepower and voltage ratings are selected output partnumber for the items. The table required is stored in sheet 2 and it looks like this.
Voltage HP
15 20 25 30 35 40
208 P# P# P# P# P# P#
230 P# P# P# P# P# P#
460 P# P# P# P# P# P#
I cant type the table correctly on the forum ...hopefully people get the idea. The voltage column contains 208 , 230 and 460 on the left...the Hp colum is horizontal 15,20,25,30...based on the voltage and horsepower select the partnumber.
I would like the code to ouput the specific partnumbers for the softstarter according to the voltage and hp supplied on sheet 1. Is this possible using excel?...Any help would be greatly appreciated. Thanks. Btw this site rocks!