Solved

# Excel formula looking for value between 2

Posted on 2013-11-06

Hi,

I have a document and I want to use an IF function and don't know how.

Here's how it goes

I have on a sheet "table" those column

A B C

0 5 17

6 10 43

11 15 33

16 20 2

Then on the other sheet "info" I have

A

3

7

11

19

I want a formula that says on sheet "info" look at cell A1 and return the "table" C number where A1 on "info" is comprise between number of A1 A2 on the "table" sheet.

So in my example

A1 = 3, 3 is between 0 and 5 so return 17

A2 = 7 and that's between 6-10 so return 43.

A3 = 11 and that's between 11 and 15 so return 33

A4 - 19 and that's between 16-20 so return 2.

I hope that this is clear enough ;-)

tx!