Spreadsheet: 120356d1315232618-vlookup-to-return-multiple-results-lob-colocations-example
Sheet: Final Budget by Allocation

File Id | Program Cell | File Name | City | State | Expiration | Size | Documented Termination? | Not Paid Thru Lease Admin | Vacated? | Status | One-Time Monthly Avg | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-03-12 00:00:00 | 2012-04-12 00:00:00 | 2012-05-12 00:00:00 | 2012-06-12 00:00:00 | 2012-07-12 00:00:00 | 2012-08-12 00:00:00 | 2012-09-12 00:00:00 | 2012-10-12 00:00:00 | 2012-11-12 00:00:00 | 2012-12-12 00:00:00 | Total 2012 | Per RSF Rate | ADJ Rent as of 5/23/11 | Delta (Y-Z) | Reserve (Yes/No) | CRE PM Comments | [NAME] | PM Response Needed | LOB Comments | Consolidations / Relocations | Capital Needed? | NEF Chargeback % | Total 2012 Budget AFTER Chargeback's | 100% Allocations | Cost Center | Allocations | LOB | Filter to NET Sublease | Market  Ranking | Strategic Market | New Locations (PAF $'s) | Delta (Y-AS) | Lease Designation | Total 2012 (Original) | Delta (AX-AV) | Total 2012 (NET of Chargeback's) | Delta (AZ-AX) | Total 2012 (PM Calls) | Delta (BB-AZ) | Total 2012 (LOB Calls) | Delta (BD-BB) | Total 2012 Final |  | Count
AL3946 | Mid Atlantic | [NAME] | [NAME] | DE | 2020-12-31 00:00:00 | 200000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 32921.15062499999 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 360000 | 1.8 | 30000 | 330000 | 0 | Done - No Change | 0 | 0 | 0 | 0 | 0 | 0 | 360000 | YES | 10020001 | 1 | LOB 1 | 0 | 0 | DE | 0 | 0 | A | 30000 | 0 | 30000 | 0 | 30000 | 0 | 30000 | 330000 | 360000 | AL3946 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 14000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 953.351555625 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 50400 | 0.5040000000000001 | 4200 | 46200 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 50400 | NO | 10020001 | 0.14 | LOB 2 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 4200 | 0 | 4200 | 0 | 4200 | 0 | 4200 | 46200 | 50400 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 12000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 817.1584762499998 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 43200 | 0.432 | 3600 | 39600 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 43200 | NO | 10020001 | 0.12 | LOB 2 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 3600 | 0 | 3600 | 0 | 3600 | 0 | 3600 | 39600 | 43200 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 26000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 1770.510031875 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 93600 | 0.936 | 7800 | 85800 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 93600 | NO | 10020001 | 0.26 | LOB 3 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 7800 | 0 | 7800 | 0 | 7800 | 0 | 7800 | 85800 | 93600 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 15000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 1021.4480953125 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 54000 | 0.54 | 4500 | 49500 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 54000 | NO | 10020001 | 0.15 | LOB 4 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 4500 | 0 | 4500 | 0 | 4500 | 0 | 4500 | 49500 | 54000 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 7000.000000000001 | 1900-01-01 00:00:00 | 0 | 0 | Active | 476.6757778125 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 25200 | 0.2520000000000001 | 2100 | 23100 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 25200 | NO | 10020001 | 0.07 | LOB 4 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 2100 | 0 | 2100 | 0 | 2100 | 0 | 2100 | 23100 | 25200 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 3000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 204.2896190625 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 10800 | 0.108 | 900 | 9900 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 10800 | NO | 10020001 | 0.03 | LOB 4 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 900 | 0 | 900 | 0 | 900 | 0 | 900 | 9900 | 10800 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 4000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 272.3861587499999 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 14400 | 0.144 | 1200 | 13200 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 14400 | NO | 10020001 | 0.04 | LOB 5 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 1200 | 0 | 1200 | 0 | 1200 | 0 | 1200 | 13200 | 14400 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 6000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 408.5792381249999 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 21600 | 0.216 | 1800 | 19800 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 21600 | NO | 10020001 | 0.06 | LOB 4 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 1800 | 0 | 1800 | 0 | 1800 | 0 | 1800 | 19800 | 21600 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 6000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 408.5792381249999 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 21600 | 0.216 | 1800 | 19800 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 1 | 0 | NO | 10020001 | 0.06 | LOB 6 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 1800 | 0 | 1800 | 0 | 1800 | 0 | 1800 | -1800 | 0 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 4000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 272.3861587499999 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 14400 | 0.144 | 1200 | 13200 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 14400 | NO | 10020001 | 0.04 | LOB 7 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 1200 | 0 | 1200 | 0 | 1200 | 0 | 1200 | 13200 | 14400 | AL3948 - 10020001 | 1
AL3948 | Mid Atlantic | New York | New York | NY | 2020-12-31 00:00:00 | 3000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 204.2896190625 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 10800 | 0.108 | 900 | 9900 | 0 | Done - No Change | No Activity | PM to Check Allocation Change | 0 | AL3948 | YES | 0 | 10800 | NO | 10020001 | 0.03 | LOB 7 | 0 | 0 | NY - Manhattan | 0 | 0 | A | 900 | 0 | 900 | 0 | 900 | 0 | 900 | 9900 | 10800 | AL3948 - 10020001 | 1
AL3949 | Southeast | Aventura | Aventura | FL | 2020-12-31 00:00:00 | 50000 | 1900-01-01 00:00:00 | 0 | 0 | Active | 0 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 360000 | 7.2 | 30000 | 330000 | YES | Done - Set-up  Reserves | 0 | 0 | Finance to Verify and Set-up Reserves | 0 | YES | 0 | 360000 | YES | 10020001 | 1 | LOB 1 | 0 | 38 | FL - Miami | 79677.25785000001 | 280322.74215 | A | 30000 | 0 | 30000 | 0 | 30000 | 0 | 30000 | 330000 | 360000 | AL3949 - 10020001 | 1
AS3946 | Mid Atlantic | [NAME] | [NAME] | DE | 2020-12-31 00:00:00 | 30000 | 1900-01-01 00:00:00 | 0 | 0 | Active | -6.403270833333352 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 360000 | 12 | 30000 | 330000 | 0 | Done - No Change | 0 | 0 | 0 | 0 | 0 | 0 | 360000 | YES | 10020001 | 1 | LOB 1 | 0 | 0 | DE | 0 | 0 | A | 30000 | 0 | 30000 | 0 | 30000 | 0 | 30000 | 330000 | 360000 | AS3946 - 10020001 | 1
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58