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)))))))))))))