=(O74-2080)+VLOOKUP((O74-2080),myTable,3,TRUE)
where c1 has your =o74-2080
=IF(LEN(TRIM(o74))<1,"",VLOOKUP(C1,mytable,3,0))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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.