filling a table using a database while finding the nearest value for two parameter

Hi,

First I'm new to this forum and I apologize if this message is in the wrong category.
I couldn't find a response browsing your site.

My problem is:

I have a table to fill using the data of another one.
Let's say I have a huge swimming pool (x,y) and I test the Ph in various point.

Table #1 is the database (x;y;ph)
Table #2 is the swimming pool (x,y)

Here's my questions:
- I want value of every point of table#1 transcript in table#2 for the exact x and y.
- for the case where there is no data, it need to display the closest value in the the database, but for the two parameter x and y.

I found a formula for my first question that worked :
=SUMPRODUCT(($L$21:$L$25=D$9)*($M$21:$M$25=$C10)*($N$21:$N$25))
But it display 0 when the x and y are not the same from table#1, and i really need excel to calculate the closest value.

Any help would be very appreciated.

Thanks

Hi micope21,

Actually it's in the other way. I use table#2 to fill table#1.
So I tried to apply your formula in the other way. But it only displays #REF
How can I fix this?

Thanks