VLOOKUP is just too cool. Now that I know about VLOOKUP, I looked it up in
HELP. Even knowing how it works now, I don't think I could have accomplished
this from the instructions, but your instructions worked for me. Thanks.
Three of the four charts are up and running fine. The fourth is being
stubborn. It's layout is nearly identical to one of the others, which is
working fine. The only thing that raises a question is that both charts key
off of the same piece of raw data. However I have tried entering the data
twice - in two separate cells and the formula for the second chart continues
to respond with #N/A. All my links are to good data and the formulas look
identical except for the differences of the data locations and such. I've
rebuilt the formulas several times. Some by by point and click, some by
typing in the cell, and some by typing in the fx line. I've even cut and
pasted the working formula into the other cell and simply made the changes
for the data locations and such and it still returns #N/A. I'm quite new to
Excel and my competancy leans toward Computerly Challenged, so I'm quite sure
I'm the problem. Would the fact that the two charts key off of the same raw
data have anything to do with this problem? Thanks, K.

"K" wrote:

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.