Is value between 2 values of a certain criteria

[James thunderbolt]

Hi,

I am trying to figure out how to identify if a value is between the nearest 2 available values of the same criteria.

I have attached a spreadsheet showing what I mean - and in the yellow a sort of "solver" on how the equation should work - can anyone help provide a formula that would answer this for me ?

Thanks
JT

 

[Nebu]

Hi:

Is this what you are looking for?

Note:

All are array formulas execute using control+shift+enter keys.

Thanks

 

[James thunderbolt]

This is awesome thanks !!