IF Formula to Provide Price Based on 2 Different Ranges of Numbers

[Boscobus]

Hey there,

I am working on a spreadsheet to deliver 1 price if a number falls within a certain range and then a separate set of prices if it falls outside the range. I am running into a problem because the first four rows (T D 1-B D 2) have a different range of numbers from Str 1 and Str 2. The first four rows have to fall between 29-72 and the last two rows have to fall between 29-55 for the V prices to qualify. Any numbers outside of that are supposed to activate the 2" - 3" columns. I have been using IF and AND and I am stumped. I have attached an abbreviated version of the spreadsheet I'm working on. It should be calculating the V pricing, but it's not. Any help you can give would be great!

[Glenn Kennedy]

It >>might<< make more sense if you included some expected answers, manually calculated, in your sheet...

[Boscobus]

I want cells G11 through N16 to populate with the Material and Labor rates in cells C34 through D37 based on size. I attached an updated, colorcoded spreadsheet.

[JeteMc]

Perhaps the following will help:
Fill cells E2, F2 and E4 respectively with "T D", "B D" and "Str"
Populate cells G11:G16 using: =IF(AND(F11>=$C$2,IF(OR(ISNUMBER(SEARCH(E$2,B11)),ISNUMBER(SEARCH(F$2,B11))),F11<=$C$3,IF(ISNUMBER(SEARCH(E$4,B11)),F11<C$5))),$C$34,$C$7)
Populate cells H11:H16 using: =IF(AND(F11>=$C$2,IF(OR(ISNUMBER(SEARCH(E$2,B11)),ISNUMBER(SEARCH(F$2,B11))),F11<=$C$3,IF(ISNUMBER(SEARCH(E$4,B11)),F11<C$5))),$D$34,$C$7)
Let us know if you have any questions.