Bilinear interpolation EXCEL

[thavil]

I need to interpolate data from my table and I already have a way of doing so, which I learned from:
https://www.engineerexcel.com/biline...olation-excel/
However, I wanted to incorporate it to my workbook in a way it can automatically fill in the values, since I have many similar tables to work on. So I did not want to do it manually for each set of coordinates. A sample table is following:

https://i.stack.imgur.com/vi4KX.png

Someone know a way I can do it? I tried to create a VBA code from some tutorials online but did not work.
Thanks!!

 

[Hui]

Please provide the actual Excel file

Have you tried using the search box at the top right of this page

 

[Luke M]

@thavil

Please note our forum rules (and most forums have a similar rule) stating that you should indicate when you have cross-posted a question. Cross-posting is certainly encouraged, we just want to stay informed so if it's been solved elsewhere we don't waste time trying to "resolve" the issue.

https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1215172-bilinear-interpolation-excel

 

[Peter Bartholomew]

The attached contains formulas that perform a bi-linear interpolation.
It is implemented using named formulae so don't expect it to look familiar!