Here's one way:

Motor speed = column A
Tubing size = row 1

...........A..........B..........C..........D
1....................0.5.......0.75......1.0
2......1000......10.........17........25
3......1500......12.........22........30
4......2000......18.........25........37

Lookup motor speed 1500
Lookup tubing size 0.75

F1 = 1500
E1 = 0.75

=VLOOKUP(F1,A1:D4,MATCH(E1,A1:D1,0),0)

Result = 22

Biff

"K" wrote in message
...
For many years, when we were helping a customer select a model size, we
had a
preprinted form that would guide us through the multi-step process of
gathering the hard data from the customer and plugging that data into the
various formulas. In addition, there are four different charts that
provided
constants for the formulas. These constants were selected according to the
hard data provided by the customer. Someone finally put all our formulas
into
an Excel program which has sped the process tremendoulsy, but the
constants
must still be looked up and plugged in manually. Is there a way to put
these
charts in the program? For instance, "If the motor speed is X and the
tubing
size is Y, then read across the X row to the customer's X and down that
column to the customer's Y and use the number in that cell in the formula
on
page 1, C35". All ideas, comments, and suggestions will be greatly
appreciated. Thanks, K.