Im a complete rookie here so im hoping that all you gurus out there can give me some help with the project that im working on.

so basically I have a table that look like so:

Depth | Well Rate | Pressure | WGR | FBHP |

50 | 0.75 | 35 | 50 | 215.775 |

50 | 1 | 35 | 50 | 214.048 |

100 | 0.75 | 35 | 50 | 226.834 |

100 | 0.75 | 55 | 100 | 78.0548 |

150 | 1 | 85 | 100 | 115.193 |

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>

</tbody>

what im trying to do is to write a function/ macro that will tell me what the FBHP value is based on a certain Depth, Well Rate, Pressure and WGR.

I have wrote a Sumifs statement that tells me the FBHP value if the Depth, Well Rate, Pressure & WGR value is exactly the same as the number in the table.

i.e if depth is 50, well rate is 0.75 , pressure is 35 and WGR is 50. It tells me that the FBHP is 215.775

However, i was wondering is there a way which if for example, the Depth is 80, well rate is 0.9, pressure is 38 & WGR is 80. It will sort of look up to the closest line.

I.e for Depth is 80 it will go and look for the 100 value since its closest.

I hope my question makes sense.

Thanks soo much for taking a look..

please let me know if theres anything i could do..

Cheers,

Jay