Thread: Excel - Lookup between two values

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...

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

F2: =VLOOKUP(E2,$A$2:$C$11,3,1)

or

F2: =INDEX($C$2:$C$11,MATCH(E2,$A$2:$A$11,1))

Copy either formula down as far as you need.

Does that help?