Display value in a cell if between 2 other values

[alexm]

Hello,

I've attached an excel file with the format and info on how the formula should work.

Any help would be greatly appreciated.

[patel]

you can solve with simple IF formula, see attached

[Bob Phillips]

Even simpler, invert the second table and use

=INDEX($H$4:$H$8,MATCH(C4,$F$4:$F$8,1))