Spreadsheet: 859984d1708217718-xlookup-maybe-nested-indirect-and-excel-tables-to-get-value-example_template-redesigned
Sheet: Tables

Status |  | Project Customers |  | Project |  |  | Sponsor |  |  | [NAME]) |  | Agreements |  | Period | Month # | Month | Obl | Exp |  | Period | Month # | Month | Obl | Exp |  | Period | Month # | Month | Obl | Exp
Complete |  | Customer A |  | Project 1 |  |  | Sponsor 1 |  |  | O&M |  | 7600A |  | 1 | 10 | Oct | 0.083 | 0.063 |  | 1 | 10 | Oct | 0.075 | 0.046 |  | 1 | 10 | Oct | 0.067 | N/A
Ahead of schedule |  | Customer B |  | Project 2 |  |  | Sponsor 2 |  |  | RDTE |  | [NAME] |  | 1 | 11 | Nov | 0.167 | 0.125 |  | 1 | 11 | Nov | 0.15 | 0.092 |  | 1 | 11 | Nov | 0.133 | N/A
On track |  | Customer C |  | Project 3 |  |  | Sponsor 3 |  |  | PROC |  | LOA |  | 1 | 12 | Dec | 0.25 | 0.188 |  | 1 | 12 | Dec | 0.225 | 0.138 |  | 1 | 12 | Dec | 0.2 | N/A
Behind schedule |  | Customer D |  | Project 4 |  |  |  |  |  | O&M; RDTE |  | MOA |  | 1 | 1 | Jan | 0.333 | 0.25 |  | 1 | 1 | Jan | 0.3 | 0.183 |  | 1 | 1 | Jan | 0.267 | N/A
Past due |  | Customer E |  | Project 5 |  |  |  |  |  | O&M; PROC |  | MOU |  | 1 | 2 | Feb | 0.417 | 0.313 |  | 1 | 2 | Feb | 0.375 | 0.229 |  | 1 | 2 | Feb | 0.333 | N/A
Not started |  |  |  |  |  |  |  |  |  | RDTE; PROC |  | Verbal |  | 1 | 3 | Mar | 0.5 | 0.375 |  | 1 | 3 | Mar | 0.45 | 0.275 |  | 1 | 3 | Mar | 0.4 | N/A
 |  |  |  |  |  |  |  |  |  | O&M; RDTE; PROC |  |  |  | 1 | 4 | Apr | 0.583 | 0.438 |  | 1 | 4 | Apr | 0.525 | 0.321 |  | 1 | 4 | Apr | 0.467 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | May | 0.667 | 0.5 |  | 1 | 5 | May | 0.6 | 0.367 |  | 1 | 5 | May | 0.533 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6 | Jun | 0.75 | 0.563 |  | 1 | 6 | Jun | 0.675 | 0.413 |  | 1 | 6 | Jun | 0.6 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 | Jul | 0.833 | 0.625 |  | 1 | 7 | Jul | 0.75 | 0.458 |  | 1 | 7 | Jul | 0.667 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8 | Aug | 0.917 | 0.688 |  | 1 | 8 | Aug | 0.825 | 0.504 |  | 1 | 8 | Aug | 0.733 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 | Sep | 1 | 0.75 |  | 1 | 9 | Sep | 0.9 | 0.55 |  | 1 | 9 | Sep | 0.8 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 10 | Oct | 1 | 0.771 |  | 2 | 10 | Oct | 0.908 | 0.579 |  | 2 | 10 | Oct | 0.808 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 11 | Nov | 1 | 0.792 |  | 2 | 11 | Nov | 0.917 | 0.608 |  | 2 | 11 | Nov | 0.817 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 12 | Dec | 1 | 0.813 |  | 2 | 12 | Dec | 0.925 | 0.638 |  | 2 | 12 | Dec | 0.825 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | Jan | 1 | 0.833 |  | 2 | 1 | Jan | 0.9329999999999999 | 0.667 |  | 2 | 1 | Jan | 0.833 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | Feb | 1 | 0.854 |  | 2 | 2 | Feb | 0.9420000000000001 | 0.696 |  | 2 | 2 | Feb | 0.842 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | Mar | 1 | 0.875 |  | 2 | 3 | Mar | 0.95 | 0.725 |  | 2 | 3 | Mar | 0.85 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | Apr | 1 | 0.896 |  | 2 | 4 | Apr | 0.958 | 0.754 |  | 2 | 4 | Apr | 0.858 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | May | 1 | 0.917 |  | 2 | 5 | May | 0.9670000000000001 | 0.783 |  | 2 | 5 | May | 0.867 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6 | Jun | 1 | 0.938 |  | 2 | 6 | Jun | 0.975 | 0.813 |  | 2 | 6 | Jun | 0.875 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 | Jul | 1 | 0.958 |  | 2 | 7 | Jul | 0.983 | 0.842 |  | 2 | 7 | Jul | 0.883 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 8 | Aug | 1 | 0.979 |  | 2 | 8 | Aug | 0.992 | 0.871 |  | 2 | 8 | Aug | 0.892 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 9 | Sep | 1 | 1 |  | 2 | 9 | Sep | 1 | 0.9 |  | 2 | 9 | Sep | 0.9 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 10 | Oct | 1 | 1 |  | 3 | 10 | Oct | 1 | 0.908 |  | 3 | 10 | Oct | 0.908 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 11 | Nov | 1 | 1 |  | 3 | 11 | Nov | 1 | 0.917 |  | 3 | 11 | Nov | 0.917 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 12 | Dec | 1 | 1 |  | 3 | 12 | Dec | 1 | 0.925 |  | 3 | 12 | Dec | 0.925 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | Jan | 1 | 1 |  | 3 | 1 | Jan | 1 | 0.933 |  | 3 | 1 | Jan | 0.933 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | Feb | 1 | 1 |  | 3 | 2 | Feb | 1 | 0.942 |  | 3 | 2 | Feb | 0.942 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | Mar | 1 | 1 |  | 3 | 3 | Mar | 1 | 0.95 |  | 3 | 3 | Mar | 0.95 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | Apr | 1 | 1 |  | 3 | 4 | Apr | 1 | 0.958 |  | 3 | 4 | Apr | 0.958 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5 | May | 1 | 1 |  | 3 | 5 | May | 1 | 0.967 |  | 3 | 5 | May | 0.967 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | Jun | 1 | 1 |  | 3 | 6 | Jun | 1 | 0.975 |  | 3 | 6 | Jun | 0.975 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7 | Jul | 1 | 1 |  | 3 | 7 | Jul | 1 | 0.983 |  | 3 | 7 | Jul | 0.983 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8 | Aug | 1 | 1 |  | 3 | 8 | Aug | 1 | 0.992 |  | 3 | 8 | Aug | 0.992 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 9 | Sep | 1 | 1 |  | 3 | 9 | Sep | 1 | 1 |  | 3 | 9 | Sep | 1 | N/A