returning number based on intervals

[PT]

Hi to all in the forum,

I have a doubt related with a returning number based on intervals. I have a table like this:

1-10 - 20€
11- 20 - 17€
21- 30 - 14€

and so on...

The I have in one row a list of number
1
2
3

until 100. And what I want is until number 10 return 20€ from 11 to 20 return 17e and so on...

I'm using this formula =IF((B3<=$F$3:$F$8);$G$3:$G$8)

It works until number 10 on the 11 returns False...

Thanks in advance for any help.

Regards.
Ismael

 

[Aladin Akyurek]

Here is a set up:

A1: 1
A2: 11
A3: 21

B1: 10
B2: 20
B3: 30

C1: 20
C2: 17
C3: 14

Now enter a value of interest, say in E1, 13 for example. You can use either one of the following in F1...

=VLOOKUP(E1,$A$1:$C$3,3,1)

=INDEX($C$1:$C$3,MATCH(E1,$A$1:$A$3,1))

=LOOKUP(E1,$A$1:$A$3,$C$1:$C$3)

 

[gaz_chops]

Try

=LOOKUP(B3,$F$3:$G$8)

F3:G8 refers to the small table

[TABLE="width: 522"]
<tbody>[TR]
[TD="width: 87, align: right"]1[/TD]
[TD="width: 87, align: right"]20[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl64, align: right"]€ 20[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl64, align: right"]€ 17[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]21[/TD]
[TD="class: xl64, align: right"]€ 14[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl64, align: right"]€ 11[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[PT]

Perfect! Thanks for the help.