Hi Clare,

Sounds like you are talking about some sort
of test with a proving ring. If that is the case
there will be an equation that fits your calibration
data, and you should be able to do away with
the VLOOKUP.

Please post more detail of what you are trying
to achieve.

HTH
Martin


wrote in message
...
Apologies if the answer to this question is in some 'obvious' place --
I've not found it if it is!

Is there a provision (other than using some arbitrary cell swomewhere)
for creating (one or more) intermediate results to be used in
worksheet function evaluation?

(I'm using Excell 2003 SP3)

An example formula would be:

=(O74-2080)+VLOOKUP((O74-2080),myTable,3,TRUE)

What I'd like to be able to do is only enter (O74+2080) once (in the
interest of simplifying possible future editing.)

By way of explanation:

-- 'myTable' is a named range containing an interpolation table
consisting of the columns 'True Load', 'Dial Reading' and 'Difference'

-- The application is generation of a worksheet showing the actual
target dial value expected after adjusting for tare weight and a non-
linear calibration value.