Spreadsheet: 791443d1660339013-simplify-excel-formula-more-than-64-levels-of-nested-monthly-cost-quotation-variations-on-a-theme-tms
Sheet: Final (TMS)

 | [NAME] keys to move between criteria | [NAME]: | =VALUE(IFERROR(INDEX(I$9:W$46,MATCH($C$8,$H$9:$H$46,0),MATCH($E$7,$I$7:$W$7,0)+MATCH($B$7,$I$8:$K$8,0)-1),"not found"))
 |  |  | Sheet is protected - no password
 |  |  | Added DV to cell C8
 |  |  | (to protect slider values)
 | Select Service Level | Select Square Footage |  | Select Frequency | Monthly Cost
 | Standard |  |  | 4X a week |  |  |  | 1x a week |  |  | 2x a week |  |  | 3x a week |  |  | 4x a week |  |  | 5x a week
 | 2500 | 11500 | ft² |  |  |  | Ft² | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete
 |  |  |  |  |  |  | 2000 | 320 |  |  | 496 |  |  | 600 |  |  | 705 |  |  | 810
 |  |  |  |  |  |  | 2500 | 345 |  |  | 524 |  |  | 345 |  |  | 345 |  |  | 345
 |  |  |  |  |  |  | 3000 | 369 |  |  | 560 |  |  | 369 |  |  | 369 |  |  | 369
 |  |  |  |  |  |  | 3500 | 392 |  |  | 585 |  |  | 392 |  |  | 392 |  |  | 392
 |  |  |  |  |  |  | 4000 | 414 |  |  | 614 |  |  | 414 |  |  | 414 |  |  | 414
 |  |  |  |  | 1X a week | Standard | 4500 | 435 |  |  | 642 |  |  | 435 |  |  | 435 |  |  | 435
 |  |  |  |  | 2X a week | Deep | 5000 | 455 |  |  | 670 |  |  | 455 |  |  | 455 |  |  | 455
 |  |  |  |  | 3X a week | Complete | 5500 | 474 |  |  | 555 |  |  | 474 |  |  | 474 |  |  | 474
 |  |  |  |  | 4X a week |  | 6000 | 492 |  |  | 585 |  |  | 492 |  |  | 492 |  |  | 492
 |  |  |  |  | 5X a week |  | 6500 | 509 |  |  | 615 |  |  | 509 |  |  | 509 |  |  | 509
 |  |  |  |  |  |  | 7000 | 525 |  |  | 644 |  |  | 525 |  |  | 525 |  |  | 525
 |  |  |  |  |  |  | 7500 | 541 |  |  | 673 |  |  | 541 |  |  | 541 |  |  | 541
 |  |  |  |  |  |  | 8000 | 556 |  |  | 702 |  |  | 556 |  |  | 556 |  |  | 556
 |  |  |  |  |  |  | 8500 | 570 |  |  | 730 |  |  | 570 |  |  | 570 |  |  | 570
 |  |  |  |  |  |  | 9000 | 583 |  |  | 758 |  |  | 583 |  |  | 583 |  |  | 583
 |  |  |  |  |  |  | 9500 | 595 |  |  | 785 |  |  | 595 |  |  | 595 |  |  | 595
 |  |  |  |  |  |  | 10000 | 606 |  |  | 812 |  |  | 606 |  |  | 606 |  |  | 606
 |  |  |  |  |  |  | 10500 | 616 |  |  | 838 |  |  | 616 |  |  | 616 |  |  | 616
 |  |  |  |  |  |  | 11000 | 625 |  |  | 864 |  |  | 625 |  |  | 625 |  |  | 625
 |  |  |  |  |  |  | 11500 | 627 |  |  | 889 |  |  | 627 |  |  | 627 |  |  | 627
 |  |  |  |  |  |  | 12000 | 639 |  |  | 913 |  |  | 639 |  |  | 639 |  |  | 639
 |  |  |  |  |  |  | 12500 | 650 |  |  | 934 |  |  | 650 |  |  | 650 |  |  | 650
 |  |  |  |  |  |  | 13000 | 661 |  |  | 956 |  |  | 661 |  |  | 661 |  |  | 661
 |  |  |  |  |  |  | 13500 | 672 |  |  | 977 |  |  | 672 |  |  | 672 |  |  | 672
 |  |  |  |  |  |  | 14000 | 683 |  |  | 997 |  |  | 683 |  |  | 683 |  |  | 683
 |  |  |  |  |  |  | 14500 | 693 |  |  | 1016 |  |  | 693 |  |  | 693 |  |  | 693
 |  |  |  |  |  |  | 15000 | 703 |  |  | 1034 |  |  | 703 |  |  | 703 |  |  | 703
 |  |  |  |  |  |  | 15500 | 713 |  |  | 1051 |  |  | 713 |  |  | 713 |  |  | 713
 |  |  |  |  |  |  | 15500 | 728 |  |  | 1067 |  |  | 728 |  |  | 728 |  |  | 728
 |  |  |  |  |  |  | 16000 | 737 |  |  | 1082 |  |  | 737 |  |  | 737 |  |  | 737
 |  |  |  |  |  |  | 16500 | 746 |  |  | 1100 |  |  | 746 |  |  | 746 |  |  | 746
 |  |  |  |  |  |  | 17000
 |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  | 18000
 |  |  |  |  |  |  | 18500
 |  |  |  |  |  |  | 19000
 |  |  |  |  |  |  | 19500
 |  |  |  |  |  |  | 20000