You will need to spell that out in more detail - at least for me!
Maybe make up an analogous example.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mrl" wrote in message
...
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