VBA code of worksheet functions for linear and bilinear interpolation based on the signature of interp1 and interp2 in MATLAB.
The code is in Interpolation.bas and an example spreadheet is also provided.
Example of using the interp1 function:
Example of using the interp2 function:
note for inrerp2, the first arguemnt, xAxis, must be a vertical range, and the second argument, yAxis, must be a horizontal range.