Say your interpolated value is in Sheet1 cell F1,
Put this in the other Sheet
=Sheet1!F1

You can reference another sheet like that
in any formula.

HTH
Martin



"Oligo" wrote in message
...


"MartinW" wrote:

Hi Oligo,

If you are looking for a straight line fit between
data points, try this approach.

Put this formula in D1 and drag it down to D4
=IF(AND($E$1=A1,$E$1<=A2),TREND(B1:B2,A1:A2,$E$1) ,0)

In F4 put this
=MAX(D1:D4)

Put a new value for A into E1
and F1 will reflect the corresponding B value.

HTH
Martin

thanks martin. but now i got another issue. your interpolate formula solve
the problem. but i need the interpolated value to be reference in formula
on
another worksheet. so now i dont know how to reference to the cell since
the
interpolation values will only be adjacent to the cell that match the if
analysis.