Need help with pay chart, if values between x-y then pay x

[SHAWNR]

I am building (trying to build) a rudimentary automated pay sheet for my subcontractor pay sheet.... I put in all the data on the main sheet and I want the data to auto populate in the pay sheet, i have most of it done but stuck on a simple problem... keep in mind i am new to excel so the simplicity of my chart might look childish. Thanks in advance
see attached

so my 2 sheets are MAIN DATA AND SUBCONTRACTOR PAY.
All the info on my main data page transfers into my subcontractor pay sheet.. but on my subcontractor pay sheet where it populates the grass installed in column D I want it to input the calculation of the chart located at A29 and translate thoes values in total to D26
so D4 and D6 pay at .90 per sq ft
and D7, D8 and D9 pay at .85 per sq ft so the total at D26 should total $2060
See work sheet attached..
I used
=IFERROR(VLOOKUP('MAIN DATA'!$L5,GRASS_NAMES,2,0),"0")
on the main data page to find the prices of my grass but cant get that to work in this situation..

Thanks everybody

[jason.b75]

Change the values in A30:E30 to

0, 500, 1000, 2000, 3000

So that each cell only shows the minimum area for each rate.

Next remove the $ symbol and /sqft from all of the cells in row 31, so that each only shows a decimal value. 0.90, 0.85 etc.

Then in D26, enter

=Table31[[#Totals],[GRASS]]*HLOOKUP(Table31[[#Totals],[GRASS]],A30:E31,2)

Use the same method for putting green and E26.