Formula for rounding using a specific list

[EricHocking]

Ok, so i'm doing up sizes and prices for my company and I have a certain lists of values in column AG from AG3 to AG13, in another column I have the offset values. I need a formula for automatically setting the values in column 'F' from F5 to F19 to the next highest value on the list based on the values from E5 to E19. Here are my values:
500
750
1000
1250
1500
1750
2000
2250
2500
2750
3000
Anyone able to help? I'm terrible with formulas so i'm hoping soomeone knows how to do it tbh.

 

[oldbrewer]

do you mean if you choose 900 you want 1000 to be returned ?

 

[oldbrewer]

500	750
750	1000
1000	1250
1250	1500
1500	1750
1750	2000					col G
2000	2250
2250	2500				row 8	600	750	#####
2500	2750					751	1000
2750	3000					2700	2750
3000	3250					2999	3000
					easiest way is to use a lookup table
					#####
					=VLOOKUP(G8,mytable,2)

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

500	750
750	1000
1000	1250
1250	1500
1500	1750
1750	2000					col G
2000	2250
2250	2500				row 8	600	750	#####
2500	2750					751	1000
2750	3000					2700	2750
3000	3250					2999	3000
					easiest way is to use a lookup table
					#####
					=VLOOKUP(G8,mytable,2)
				col E
				or if you really want a formula
			row 32	600	750	#####
				751	1000
				2700	2750
				2999	3000
				#####
				=(INT(E32/250)+1)*250

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>