I need Excel to look in Cell F29 and populate (with one numerical value from
F5:F14) only one of the series of cells H5:H14 dependent on results in F29
falling between ranges set in B5:B14. I know the fomula needs to reside in
H5:H14, but the rest is over my head.

F29 is the result of C27/E27