Excel - Lookup between two values

[acefreemok]

I'm trying to create a formula that will look at a column of values and then give me a result depending on whether the value is between two amounts...

For the spreadsheet attached, I'm after the value in column C depending, based on the lookup number that appears in column E.
The result of should appear in column F...

What is the formula for achieving this?

Thank you in advance...

[Ron Coderre]

Using your posted workbook, here are two regular formulas that return the values you're looking for:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Copy either formula down as far as you need.

Does that help?

[acefreemok]

First one seems to work well... Thank you (I was so close)...