Pull the next highest data

[SAdam]

Hi- I would like to pull the amount from the chart, but to the next highest number. When I go to pull like 3390 it pulls the 3300 amount, I need the 3400 amount- Any ideas, thanks

Date:	Reading	Usage	Chart amount	<gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15494899049403146297614">Avb</gwmw> Charge	MO Fee	Sub-	<gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15494898893754428221659">Pentalty</gwmw>	Sub-	Credit/Balance due	Total Due
7/31/2018	256390	3390	$ 11.72	$ 11.00	$ 0.25	$ 22.97	$ -	$ 22.97	$ -	$ 22.97
9/3/2018	261320	4930	$ 17.41	$ 11.00	$ 0.25	$ 28.66	$ -	$ 28.66	$ -	$ 28.66
10/7/2018	266440	5120	$ 18.47	$ 11.00	$ 0.25	$ 29.72	$ -	$ 29.72	$ -	$ 29.72
11/1/2018	269940	3500	$ 12.43	$ 11.00	$ 0.25	$ 23.68	$ -	$ 23.68	$ -	$ 23.68
12/3/2018	273990	4050	$ 17.76	$ 11.00	$ 0.25	$ 29.01	$ -	$ 29.01	$ -	$ 29.01
12/31/2018	277550	3560	$ 12.08	$ 11.00	$ 0.25	$ 23.33	$ -	$ 23.33	$ (4.26)	$ 19.07
2/2/2019	281450	3900	$ 13.85	$ 11.00	$ 0.25	$ 25.10	$ -	$ 25.10	$ -	$ 25.10
		-281450		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0		$ 11.00	$ 0.25	$ 11.25		$ 11.25		$ 11.25
		0				$ -		$ -		$ -
Used	Cost
100	0.36
200	0.71
300	1.07
400	1.42
500	1.78
600	2.13
700	2.49
800	2.84
900	3.20
1000	3.55
1100	3.91
1200	4.26
1300	4.62
1400	4.97
1500	5.33
1600	5.68
1700	6.04
1800	6.39
1900	6.75
2000	7.11
2100	7.46
2200	7.82

<tbody>
</tbody>

 

[CyrusTheVirus]

Sounds like you need to be a bit more specific. Where is the 3400 number pulling from?

 

[SAdam]

s?drawkcab ti si yhW

 

[SAdam]

Sorry, I am looking to pull the usage amount from the chart below, to get the cost amount.

 

[CyrusTheVirus]

is the full chart not listed?

 

[SAdam]

No, the 3390 was just a sample. It should apply to any number. So, if my usage was 150, I need it ot pull the amount for 200, not the 100. If that makes sence.

 

[CyrusTheVirus]

No, the 3390 was just a sample. It should apply to any number. So, if my usage was 150, I need it ot pull the amount for 200, not the 100. If that makes sence.

assuming your usage and cost are in columns A and B, try the below formula which assumes your usage increases by the 100.

=VLOOKUP(ROUNDUP($F2,-2),$A$2:$B$41,2,0)