Hello,
I believe you are looking for the interp1 function: https://www.originlab.com/doc/X-Function/ref/interp1
https://www.originlab.com/doc/en/Origin-Help/FitRef-FindVal-StandardCurve
The script works for interpolating both X from Y and Y from X values. Just swap your Y values and X values. The code may look something like this:
interp1 -r 2 ix:=[Book1]Sheet1!D iy:=[Book1]Sheet1!(B,A) method:=linear option:=extrap;
The above example would interpolate X values from Y values assuming I had the columns set up like this: col(A):X1, col(B):Y1, col(C):X2 (blank), col(D):Y2 (values at which X2 will be interpolated)
Let me know if this is successful.
Best,
Nicholas G.
nicholas@originlab.com
OriginLab Technical Support Team