Interpolate values equation (almost complete)

[brandon20]

Hi,

I have this equation. It works great for single wells. But I need it to work for multiple wells.

=INDEX(Surface!$C$2:$C$81,MATCH(IFERROR(LARGE(Surface!$B$2:$B$81,COUNTIF(Surface!$B$2:$B$81,">"&B2)+1),MIN(Surface!$B$2:$B$81)),Surface!$B$2:$B$81,0))

This equation goes in and interpolates the surface from the worksheet "Surface" and inputs it in column D of the FPRESS Worksheet below, (as shown)

So this works perfectly, but only for one well at a time, I need the equation to also look into column A (Wellname), and run the equation for each different wellname.
Sounds easy enough, I just dont know how to do it.

Any help is appreciated, thank you!


FPRESS worksheet:

WELLNAME	DEPTH	FPRESS	Surface
RA-0062	7375	-999.25	MaB
RA-0062	7376	2741	MaB
RA-0062	7384	2746	MaB_Mrk2
RA-0062	7384	2744	MaB_Mrk2
RA-0062	7390	2747	MaB_Mrk3
RA-0062	7413	2755	MaC2
RA-0062	7428	2760	MaC4
RA-0062	7430	-999.25	MaC4
RA-0062	7451	2766	MaD_Mrk1
RA-0062	7470	2773	MaD_Mrk3
RA-0062	7485	-999.25	MaE
RA-0062	7492	2779	MaE
RA-0062	7504	2779	MaE_Mrk1
RA-0062	7514	2787	MaE_Mrk2
RA-0062	7524	2790	MaE_Mrk3
RA-0062	7548	2796	MaF_Upper_M
RA-0062	7570	-999.25	MaG_Mrk0
RA-0062	7578	2798	MaG_Mrk0
RA-0062	7578	2800	MaG_Mrk0
RA-0062	7584	2808	MaG_Mrk00
RA-0062	7592	2812	MaG_Mrk00
RA-0062	7655	3606	MaI1

<tbody>
</tbody>

"Surface" Worksheet:

Wellname	MD	Surface
RA-0062	7355.22	MaA
RA-0062	7359.37	MaA_Mrk1
RA-0062	7366.97	MaA_L
RA-0062	7368.74	MaA_Mrk2
RA-0062	7371.69	MaB
RA-0062	7371.69	MaB_Mrk1
RA-0062	7378.1	MaB_Mrk2
RA-0062	7384.44	MaB_Mrk3
RA-0062	7392.09	MaC
RA-0062	7397.5	MaC1
RA-0062	7405.43	MaC2
RA-0062	7414.15	MaC3
RA-0062	7418.5	MaD

<tbody>
</tbody>