Finding Nearest value using Index/Match

Hi All,

I am trying to find the nearest match based on two criteria.

Formula works fine when looking for perfect match, but fails when looking for nearest match.

Not sure what I am doing wrong.

Please see the attached spreadsheet.

Any guidance is most appreciated.

Hi Bo_Ry,

WOW!!!!!!!!

what you have put together here is nothing like what I would have done in 100 years. That is superb mate. :-)

I am astounded at your knowledge!!!

Thanks

Hi Bo-Ry,

the formula you created to find the nearest match also works for finding the exact match.

This is really great, because I can reduce the coding associated with a linear regression that relies on these exact and nearest matches.

Perfect......