Greater than / Less than formula help

[c1penland]

Cell P4 has a percentage in it. What I need to do is have a formula that if P4 falls between the table below the dollar amount is displayed in Q4. Any help You can offer would be greatly appreciated

Column R Column S Column T

Row 12 0%	24%	$0.00
Row 13 25%​	26%	$1.00
Row 14 27%​	28%	$2.00
Row 15 29%​	30%	$4.00
Row 16 31%​	33%	$5.00
Row 17 34%​	36%	$6.00
Row 18 37%​	39%	$7.00
Row 19 40%​	100%	$8.00

<tbody>
</tbody>

 

[wideboydixon]

Book1
	P	Q	R	S	T
4	33%	$5.00
12			0%	24%	$0.00
13			25%	26%	$1.00
14			27%	28%	$2.00
15			29%	30%	$4.00
16			31%	33%	$5.00
17			34%	36%	$6.00
18			37%	39%	$7.00
19			40%	100%	$8.00
Sheet1

Cell Formulas
Range	Formula
Q4	=VLOOKUP($P4,$R$12:$T$19,3,TRUE)

WBD

 

[AlanY]

try

=LOOKUP(P4,R12:R19,T12:T19)

 

[markmzz]

Cell P4 has a percentage in it. What I need to do is have a formula that if P4 falls between the table below the dollar amount is displayed in Q4. Any help You can offer would be greatly appreciated

Column R Column S Column T

Row 12 0%	24%	$0.00
Row 13 25%​	26%	$1.00
Row 14 27%​	28%	$2.00
Row 15 29%​	30%	$4.00
Row 16 31%​	33%	$5.00
Row 17 34%​	36%	$6.00
Row 18 37%​	39%	$7.00
Row 19 40%​	100%	$8.00

<tbody>
</tbody>

Hi!

Try this in Q4

=LOOKUP(P4,$R$12:$T$19)

	O	P	Q	R	S	T	U
1
2
3		%	Result
4		35%	6,00
5
6
7
8
9
10
11				Column R	Column S	Column T
12				0%	24%	0,00
13				25%	26%	1,00
14				27%	28%	2,00
15				29%	30%	4,00
16				31%	33%	5,00
17				34%	36%	6,00
18				37%	39%	7,00
19				40%	100%	8,00
20
21
***	**	*******	*******	*********	*********	*********	**

<colgroup><col><col><col span="2"><col span="3"><col></colgroup><tbody>
</tbody>

Markmzz