# Interpolate values equation (almost complete)

#### brandon20

##### Board Regular
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>

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Replies
3
Views
291
Replies
1
Views
241

1,207,424
Messages
6,078,448
Members
446,339
Latest member
keogata

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back