Nesting more than 7 functions

[tjaques]

Help! The current formula is listed below and works just fine. However, I
have altered our worksheet and now have 15 options instead of just 7. Where do I go from here if I can't nest any further than this. I've used VLOOKUP in the past but can't seem to get a grasp on how to add the formula into the result.

=IF(D11=0,0,IF('Area Specs.'!L11=1,(D11*'Staffing &
Pricing'!$F$65),(IF('Area Specs.'!L11=2,D11*'Staffing &
Pricing'!$G$65,(IF('Area Specs.'!L11=3,D11*'Staffing &
Pricing'!$H$65,(IF('Area Specs.'!L11=4,D11*'Staffing &
Pricing'!$I$65,IF('Area Specs.'!L11=5,D11*'Staffing &
Pricing'!$J$65,(IF('Area Specs.'!L11=6,D11*'Staffing &
Pricing'!$K$65,(IF('Area Specs.'!L11=7,D11*'Staffing & Pricing'!$L$65,'Bid
Schedule'!F11)))))))))))))

 

[Aladin Akyurek]

=IF(D11=0,0,D11*INDEX('Staffing & Pricing'!$F$65:$L$65,'Area Specs.'!L11))

 

[Andrew Poulsom]

Including the reference to Bid Schedule:

=IF(D11=0,0,IF('Area Specs.'!L11>7,'Bid Schedule'!F11,D11*INDEX('Staffing & Pricing'!$F$65:$L$65,,'Area Specs.'!L11)))