Find the INDEX/MATCH formulas
Data operationsMediumLLM judge scoringLatest run
Passed by 10 of 12 products on their best model. Failed: Copilot in Excel and Gemini in Sheets.
Prompt
Which cells use an INDEX(MATCH) type of formula in this workbook?
Ex 1 - LBO
Starting sheet · rows 1–21 of 95 and columns B–K of 36| B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | Master Control | |||||||||
| 4 | Company Name | Amdocs | ||||||||
| 5 | Ticker | NASDAQ: DOX | ||||||||
| 6 | Units in $ | Millions | ||||||||
| 7 | Units Converter | 1,000.0 | ||||||||
| 8 | Circ | 1 | ||||||||
| 9 | Operating Case | 1 | ||||||||
| 10 | M&A Switch | 1 | ||||||||
| 11 | M&A Purchase EBITDA Multiple | 14.2x | ||||||||
| 12 | ||||||||||
| 13 | Amdocs - Control | Amdocs - Forecast Drivers | ||||||||
| 14 | ||||||||||
| 15 | Acquisition Assumptions | Sources & Uses | PF P&L Drivers | |||||||
| 16 | Entry Valuation Metric | EBITDA | Sources | 2026P | 2027P | 2028P | ||||
| 17 | Entry EBITDA - FY2025 | $802.4 | Expected Revolver Draw | $0.0 | Revenue Growth | 4.0% | 5.2% | 6.4% | ||
| 18 | Entry EBITDA Multiple | 14.2x | Senior Secured TLB | $3,209.6 | Base Case | 4.0% | 5.2% | 6.4% | ||
| 19 | Exit Valuation Metric | EBITDA | PIK Debt | $0.0 | Upside Case | 4.0% | 5.2% | 6.4% | ||
| 20 | Exit EBITDA Multiple | 14.2x | Management Rollover | $199.3 | Downside Case | 4.0% | 5.2% | 6.4% | ||
| 21 | Amortization of Financing Fees | – | Sponsor Equity | $8,101.8 |
Ex 2 - Valuation Bridge
Starting sheet · rows 2–8 of 35| B | C | |
|---|---|---|
| 2 | Amdocs (DOX) - Valuation Bridge | |
| 3 | Starting Equity | $8,301.2 |
| 4 | Transaction Fees | ($114.0) |
| 5 | EBITDA Growth | $8,146.5 |
| 6 | Debt Paydown | $3,340.3 |
| 7 | Multiple Expansion | $0.0 |
| 8 | Exit Equity | $19,673.9 |
Ex 3 - PF P&L
Starting sheet · rows 1–21 of 30| B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|
| 1 | 2026 | 2027 | 2028 | 2029 | 2030 | |||
| 2 | ||||||||
| 3 | ||||||||
| 4 | Case | 1 | ||||||
| 5 | M&A Switch | 1 | ||||||
| 6 | ||||||||
| 7 | Amdocs - PF P&L | |||||||
| 8 | ||||||||
| 9 | PF P&L | |||||||
| 10 | ||||||||
| 11 | ($ in millions) | 2026P | 2027P | 2028P | 2029P | 2030P | 26P - '30P CAGR | |
| 12 | Revenue | |||||||
| 13 | Amdocs | $4,714.3 | $4,959.5 | $5,276.9 | $5,688.5 | $6,211.8 | 7.1% | |
| 14 | M&A | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | ||
| 15 | Total Revenue | $4,714.3 | $4,959.5 | $5,276.9 | $5,688.5 | $6,211.8 | 7.1% | |
| 16 | % YoY Growth | 4.0% | 5.2% | 6.4% | 7.8% | 9.2% | ||
| 17 | ||||||||
| 18 | Gross Profit | |||||||
| 19 | Amdocs | $1,675.8 | $1,842.3 | $2,044.6 | $2,306.5 | $2,630.5 | 11.9% | |
| 20 | M&A | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | ||
| 21 | Total Gross Profit | $1,675.8 | $1,842.3 | $2,044.6 | $2,306.5 | $2,630.5 | 11.9% |
Ex 4 - Organic Operating Model
Starting sheet · rows 1–21 of 42 and columns B–K of 31| B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | |
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | Case | 1 | ||||||||
| 5 | ||||||||||
| 6 | Amdocs - Organic Operating Model | |||||||||
| 7 | ||||||||||
| 8 | Active Case | |||||||||
| 9 | ($ in millions) | 2022A | 2023A | 2024A | 2025A | 2026P | 2027P | 2028P | 2029P | 2030P |
| 10 | ||||||||||
| 11 | P&L | |||||||||
| 12 | Managed Services Arrangements | 2,755.5 | 2,856.8 | 2,904.9 | 2,996.0 | |||||
| 13 | Others | 1,821.2 | 2,030.9 | 2,100.1 | 1,537.0 | |||||
| 14 | Total Revenue | $4,576.7 | $4,887.8 | $5,005.0 | $4,533.0 | |||||
| 15 | ||||||||||
| 16 | Recurring Software | 1,373.0 | 1,564.1 | 1,651.6 | 1,541.2 | 1,602.9 | 1,822.6 | 2,084.4 | 2,403.4 | 2,795.3 |
| 17 | Services | 3,203.7 | 3,323.7 | 3,353.3 | 2,991.8 | 3,111.5 | 3,136.9 | 3,192.5 | 3,285.1 | 3,416.5 |
| 18 | Total Revenue | $4,576.7 | $4,887.8 | $5,005.0 | $4,533.0 | $4,714.3 | $4,959.5 | $5,276.9 | $5,688.5 | $6,211.8 |
| 19 | % YoY Growth | 6.8% | 2.4% | (9.4%) | 4.0% | 5.2% | 6.4% | 7.8% | 9.2% | |
| 20 | ||||||||||
| 21 | Revenue Drivers |
Ex 5 - M&A
Starting sheet · rows 1–20 of 84 and columns B–K of 27| B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | |||
| 2 | 2026 | 2027 | 2028 | 2029 | 2030 | 2026 | 2027 | |||
| 3 | ||||||||||
| 4 | Case | 3 | ||||||||
| 5 | ||||||||||
| 6 | Amdocs - M&A Add-On Acquisitions Target #1 | |||||||||
| 7 | ||||||||||
| 8 | - Assumes each acquisition happens mid FY (3/31) | |||||||||
| 9 | - Assumes similar target profile - case only varies by number of acquisitions per year | |||||||||
| 10 | ||||||||||
| 11 | Active Case | Base Case | ||||||||
| 12 | ($ in millions) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ($ in millions) | Year 1 | Year 2 | |
| 13 | Revenue | $30.0 | $31.8 | $33.7 | $35.7 | $37.9 | Revenue | $30.0 | $31.8 | |
| 14 | % YoY Growth | 6.0% | 6.0% | 6.0% | 6.0% | % YoY Growth | 6.0% | |||
| 15 | ||||||||||
| 16 | Gross Profit | $21.0 | $22.3 | $23.6 | $25.0 | $26.5 | Gross Profit | $21.0 | $22.3 | |
| 17 | % of Revenue | 70.0% | 70.0% | 70.0% | 70.0% | 70.0% | % of Revenue | 70.0% | 70.0% | |
| 18 | ||||||||||
| 19 | EBITDA | $6.9 | $7.3 | $7.8 | $8.2 | $8.7 | EBITDA | $7.5 | $8.0 | |
| 20 | % of Revenue | 23.0% | 23.0% | 23.0% | 23.0% | 23.0% | % of Revenue | 25.0% | 25.0% |
Support >>
Starting sheet| A | |
|---|---|
| 1 |
Ex 6 - Amdocs Historical M&A
Starting sheet · columns B–J of 249| B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|
| 2 | Amdocs - Historical M&A, 10 Years | ||||||||
| 3 | |||||||||
| 4 | Transaction Summary | ||||||||
| 5 | ($ in miillions) | ||||||||
| 6 | Announced Date | Closed Date | Transaction Type | Role | Target | Buyer/Investors | Sellers | Size | Revenue |
| 7 | Nov-07-2023 | Nov-02-2023 | Merger/Acquisition | Buyer | Astadia Inc. | Amdocs Limited (NasdaqGS:DOX) | New Harbour Partners LLC; Spring Lake Equity Partners LLC | $75.0 | - |
| 8 | Nov-07-2023 | Aug-22-2023 | Merger/Acquisition | Buyer | ProCom Consulting, Inc. | Amdocs Limited (NasdaqGS:DOX) | $37.0 | $2.2 | |
| 9 | May-10-2023 | Jul-03-2023 | Merger/Acquisition | Buyer | Service assurance business of TEOCO Corporation | Amdocs Limited (NasdaqGS:DOX) | TEOCO Corporation | $90.0 | - |
| 10 | Nov-30-2021 | Nov-15-2021 | Merger/Acquisition | Buyer | DevOpsGroup Limited (nka:Sourced Group Cloud Services Limited) | Amdocs Limited (NasdaqGS:DOX) | Business Growth Fund Limited | $26.0 | - |
| 11 | May-12-2021 | Mar-15-2021 | Merger/Acquisition | Buyer | Sourced Group Inc. | Amdocs Limited (NasdaqGS:DOX) | Comerica Bank, Banking Investments; HSBC Ventures; Round 13 Capital, Inc. | $75.0 | - |
| 12 | Jul-23-2020 | Aug-11-2020 | Merger/Acquisition | Buyer | Openet Telecom Limited | Amdocs Limited (NasdaqGS:DOX) | Balderton Capital (UK) LLP; Cipio Partners; Cross Atlantic Capital Partners LLC; Enterprise Ireland Seller Funds: Taggia | $180.0 | $63.0 |
| 13 | Aug-07-2019 | Aug-07-2019 | Merger/Acquisition | Buyer | Telecom Technology Services, Inc. | Amdocs Limited (NasdaqGS:DOX) | $50.0 | - | |
| 14 | Feb-27-2018 | - | Merger/Acquisition | Buyer | UXP Systems Inc. | Amdocs Limited (NasdaqGS:DOX) | $80.0 | - | |
| 15 | Jan-30-2018 | Feb-22-2018 | Merger/Acquisition | Buyer | Vubiquity, Inc. | Amdocs Limited (NasdaqGS:DOX) | Carlyle Group L.P. (nka:The Carlyle Group Inc. (NasdaqGS:CG)); QED Investors, LLC; The Benaroya Company, Investment Arm Seller Funds: Carly… | $224.0 | $14.7 |
| 16 | Jan-30-2018 | Dec-31-2017 | Merger/Acquisition | Buyer | projekt202, LLC. | Amdocs Limited (NasdaqGS:DOX) | $54.0 | $32.1 | |
| 17 | Sep-14-2016 | Sep-14-2016 | Merger/Acquisition | Buyer | Pontis, Inc. and Vindicia, Inc. | Amdocs Limited (NasdaqGS:DOX) | Accel Partners; DCM Ventures Inc.; FTV Management Company, L.P.; Leader Ventures; Liberty Global Ventures Holding B.V.; NVP Associates, LLC… | - | - |
| 18 | Sep-14-2016 | Sep-14-2016 | Merger/Acquisition | Buyer | Brite:Bill Limited | Amdocs Limited (NasdaqGS:DOX) | Delta Partners Limited; Enterprise Ireland; Investec Ventures Ireland Ltd Seller Funds: The Harcourt venture Fund Limited Partnership | - | $40.8 |
| 19 | Feb-03-2016 | Jan-31-2016 | Merger/Acquisition | Buyer | cVidya Networks Inc. | Amdocs Limited (NasdaqGS:DOX) | Battery Ventures L.P.; Carmel Ventures (nka:Viola Ventures); Saints Capital Services, LLC; StageOne Ventures; Viola Credit Seller Funds: Ba… | - | - |
Ex 7 - SOFR
Starting sheet · rows 2–22 of 78| B | C | D | E | |
|---|---|---|---|---|
| 2 | SOFR - Market Projections | |||
| 3 | ||||
| 4 | SOFR Market Projections | |||
| 5 | Reset Date | 1-month Term SOFR | 3-month Term SOFR | 1-Month ISDA SOFR |
| 6 | 21/11/2025 | 3.95% | 3.88% | 4.19% |
| 7 | 22/12/2025 | 3.80% | 3.76% | 3.90% |
| 8 | 21/01/2026 | 3.71% | 3.65% | 3.90% |
| 9 | 23/02/2026 | 3.67% | 3.53% | 3.79% |
| 10 | 23/03/2026 | 3.57% | 3.47% | 3.79% |
| 11 | 21/04/2026 | 3.49% | 3.41% | 3.79% |
| 12 | 21/05/2026 | 3.43% | 3.34% | 3.43% |
| 13 | 22/06/2026 | 3.32% | 3.26% | 3.43% |
| 14 | 21/07/2026 | 3.24% | 3.19% | 3.43% |
| 15 | 21/08/2026 | 3.19% | 3.14% | 3.20% |
| 16 | 21/09/2026 | 3.12% | 3.08% | 3.20% |
| 17 | 21/10/2026 | 3.08% | 3.03% | 3.20% |
| 18 | 23/11/2026 | 3.00% | 3.01% | 3.12% |
| 19 | 21/12/2026 | 3.00% | 3.00% | 3.12% |
| 20 | 21/01/2027 | 3.00% | 3.00% | 3.12% |
| 21 | 22/02/2027 | 3.00% | 3.01% | 3.12% |
| 22 | 22/03/2027 | 3.00% | 3.00% | 3.12% |
Ex 8 - Public Comps
Starting sheet · rows 2–22 of 36| B | C | D | E | F | |
|---|---|---|---|---|---|
| 2 | Amdocs - Public Comparables Analysis | ||||
| 3 | |||||
| 4 | EV/Revenue | ||||
| 5 | Company Name | 2025 Avg. | 2024 Avg. | 2023+ Max | 2023+ Min |
| 6 | Amdocs (NASDAQ: DOX) | 2.2x | 2.1x | 2.5x | 1.8x |
| 7 | CSG (NASDAQ: CSGS) | 1.8x | 1.6x | 2.0x | 1.4x |
| 8 | Lumine (TSX: LMN) | 12.0x | 13.2x | 24.2x | 2.8x |
| 9 | NetScout (NASDAQ: NTCT) | 1.5x | 1.5x | 2.7x | 1.2x |
| 10 | Optiva (TSX: OPT) | 2.3x | 2.3x | 2.7x | 1.7x |
| 11 | Radcom (NASDAQ: RDCM) | 1.8x | 1.3x | 2.1x | 0.8x |
| 12 | Subex (BSE: 532348) | 2.6x | 5.5x | 9.0x | 3.7x |
| 13 | Synchronoss (NASDAQ: SNCR) | 1.7x | 1.8x | 2.1x | 1.1x |
| 14 | Tecnotree (HLSE: TEM1V) | 1.0x | 1.1x | 2.5x | 0.6x |
| 15 | Average | 3.0x | 3.4x | 5.5x | 1.7x |
| 16 | Median | 1.8x | 1.8x | 2.5x | 1.4x |
| 17 | Max | 12.0x | 13.2x | 24.2x | 3.7x |
| 18 | Min | 1.0x | 1.1x | 2.0x | 0.6x |
| 19 | |||||
| 20 | EV/EBITDA | ||||
| 21 | Company Name | 2025 Avg. | 2024 Avg. | 2023+ Max | 2023+ Min |
| 22 | Amdocs (NASDAQ: DOX) | 10.2x | 10.5x | 11.5x | 9.2x |
Ex 9 - Transaction Comps
Starting sheet · rows 2–22 of 63| B | C | D | E | F | G | |
|---|---|---|---|---|---|---|
| 2 | Selected Transactions Analysis | |||||
| 3 | ($ in millions) | |||||
| 4 | Date | Target | Type | Total EV | Debt / EBITDA | TEV / EBITDA |
| 5 | 2024 | AssetMark Financial Holdings, Inc. | SaaS | - | 0.1x | - |
| 6 | 2023 | Blackbaud, Inc. (NasdaqGS:BLKB) | SaaS | 3,691.8 | 3.6x | 12.3x |
| 7 | 2020 | Engineering Ingegneria Informatica S.p.A. | SaaS | - | 8.3x | - |
| 8 | 2024 | Envestnet, Inc. | SaaS | - | 6.4x | 22.9x |
| 9 | 2024 | Everbridge, Inc. | SaaS | - | 34.1x | - |
| 10 | 2024 | Exclusive Networks SA | SaaS | - | 3.2x | 10.3x |
| 11 | 2024 | Fuji Soft Incorporated | SaaS | - | 1.8x | 22.7x |
| 12 | 2024 | Instructure Holdings, Inc. | SaaS | - | 5.5x | 20.5x |
| 13 | 2025 | Iress Limited (ASX:IRE) | SaaS | 1,163.0 | 2.8x | 21.3x |
| 14 | 2025 | Jamf Holding Corp. (NasdaqGS:JAMF) | SaaS | 1,956.0 | 20.6x | - |
| 15 | 2025 | MeridianLink, Inc. | SaaS | - | 8.6x | - |
| 16 | 2021 | Mphasis Limited (BSE:526299) | SaaS | 5,759.3 | 0.8x | 18.9x |
| 17 | 2025 | Sapiens International Corporation N.V. (NasdaqGS:SPNS) | SaaS | 2,381.6 | 0.5x | - |
| 18 | 2025 | SolarWinds Corporation | SaaS | - | 4.6x | 14.5 |
| 19 | 2022 | VNET Group, Inc. (NasdaqGS:VNET) | SaaS | 5,680.5 | 9.0x | 10.4x |
| 20 | 2024 | WM Technology, Inc. (NasdaqGS:MAPS) | SaaS | 127.8 | 1.0x | 3.9x |
| 21 | Average | 2,965.7 | 6.9x | 15.8x | ||
| 22 | Median | 2,381.6 | 4.1x | 16.7x |
Raw Data >>
Starting sheet| A | |
|---|---|
| 1 |
Ex 10 - Balance Sheet
Starting sheet · rows 2–22 of 32| B | C | D | E | F | |
|---|---|---|---|---|---|
| 2 | Amdocs - Condensed Consolidated Balance Sheets | ||||
| 3 | ($ in thousands) | ||||
| 4 | As of | ||||
| 5 | September 30, 2025 | September 30, 2024 | |||
| 6 | ASSETS | ||||
| 7 | Current assets: | ||||
| 8 | Cash and cash equivalents | 324,999 | 346,085 | ||
| 9 | Short-term interest-bearing investments | — | 168,242 | ||
| 10 | Accounts receivable, net, including unbilled | 935,751 | 1,028,357 | ||
| 11 | Prepaid expenses and other current assets | 331,387 | 228,498 | ||
| 12 | Total current assets | 1,592,137 | 1,771,182 | ||
| 13 | Property and equipment, net | 768,557 | 755,601 | ||
| 14 | Lease assets | 182,088 | 149,254 | ||
| 15 | Goodwill and other intangible assets, net | 3,046,962 | 3,005,637 | ||
| 16 | Other noncurrent assets | 660,086 | 704,468 | ||
| 17 | Total assets | $6,249,830 | $6,386,142 | ||
| 18 | |||||
| 19 | LIABILITIES AND SHAREHOLDERS’ EQUITY | ||||
| 20 | Current liabilities | ||||
| 21 | Accounts payable, accruals and other | 1,201,206 | 1,315,679 | ||
| 22 | Lease liabilities | 38,725 | 39,983 |
Ex 11 - Income Statement
Starting sheet · rows 1–21 of 28 and columns B–K of 12| B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | Amdocs - Consolidated Statements of Income | |||||||||
| 3 | ($ in thousands) | |||||||||
| 4 | Three months ended September 30, | Fiscal year ended September 30, | ||||||||
| 5 | 2025 (a) | 2024 | 2025 (a) | 2024 | ||||||
| 6 | Revenue | $1,150,218 | $1,263,882 | $4,532,913 | $5,004,989 | |||||
| 7 | Operating expenses: | |||||||||
| 8 | Cost of revenue | 719,878 | 824,888 | 2,811,333 | 3,249,598 | |||||
| 9 | Research and development | 87,865 | 90,069 | 340,845 | 360,798 | |||||
| 10 | Selling, general and administrative | 121,807 | 138,705 | 506,108 | 572,845 | |||||
| 11 | Amortization of purchased intangible assets and other | 14,287 | 14,333 | 62,424 | 62,052 | |||||
| 12 | Restructuring charges | 73,756 | 83,213 | 80,539 | 131,088 | |||||
| 13 | 1,017,593 | 1,151,208 | 3,801,249 | 4,376,381 | ||||||
| 14 | Operating income | 132,625 | 112,674 | 731,664 | 628,608 | |||||
| 15 | Interest and other expense, net | (11,843) | (9,237) | (38,422) | (37,537) | |||||
| 16 | Income before income taxes | 120,782 | 103,437 | 693,242 | 591,071 | |||||
| 17 | Income taxes | 23,668 | 16,261 | 125,473 | 94,750 | |||||
| 18 | ||||||||||
| 19 | Net income | $97,114 | $87,176 | $567,769 | $496,321 | |||||
| 20 | Net income attributable to noncontrolling interests | $787 | $735 | $3,065 | $3,124 | |||||
| 21 | Net income attributable to Amdocs Limited | $96,327 | $86,441 | $564,704 | $493,197 |
Ex 12 - Cash Flow Statement
Starting sheet · rows 1–21 of 44| B | C | D | E | F | G | |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | Amdocs - Consolidated Statements of Cash Flows | |||||
| 3 | ($ in thousands) | |||||
| 4 | Year Ended September 30, | |||||
| 5 | 2025 | 2024 | ||||
| 6 | Cash Flow from Operating Activities: | |||||
| 7 | Net income | $567,769 | $496,321 | |||
| 8 | Reconciliation of net income to net cash provided by operating activities: | |||||
| 9 | Depreciation, amortization and impairment | 195,435 | 195,234 | |||
| 10 | Amortization of debt issuance cost | 608 | 596 | |||
| 11 | Equity-based compensation expense | 104,864 | 104,540 | |||
| 12 | Deferred income taxes | 20,291 | (45,673) | |||
| 13 | Loss from short-term interest-bearing investments | 3,487 | 5,576 | |||
| 14 | Net changes in operating assets and liabilities, net of amounts acquired: | |||||
| 15 | Accounts receivable, net | 79,606 | (104,413) | |||
| 16 | Prepaid expenses and other current assets | (55,061) | (8,478) | |||
| 17 | Other noncurrent assets | (15,445) | (2,250) | |||
| 18 | Lease assets and liabilities, net | 3,221 | (6,485) | |||
| 19 | Accounts payable, accrued expenses and accrued personnel | (77,041) | 216,324 | |||
| 20 | Deferred revenue | 8,172 | (60,332) | |||
| 21 | Income taxes payable, net | (15,109) | (47,241) |
A passing output
Autosheet in Excel · Opus 5.5I'll scan every sheet's formulas for INDEX and MATCH. Find INDEX/MATCH formulas I checked the formulas on every sheet. 7 cells use INDEX(MATCH), and they're on 2 sheets. No other formula in the workbook uses INDEX or MATCH. Ex 1 - LBO C17: pulls row 40 (Adj. EBITDA) from Ex 4 - Organic Operating Model, matching on the year 2025, which is typed directly into the formula: =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) P17: pulls row 18 (Revenue) from Ex 4 - Organic Operating Model, matching on the year in P1: =INDEX('Ex 4 - Organic Operating Model'!C18:K18,MATCH(P1,'Ex 4 - Organic Operating Model'!C1:K1,0)) Ex 3 - PF P&L C25:G25 (Amdocs Adj. EBITDA, 2026P–2030P): these five cells pull row 40 from Ex 4 - Organic Operating Model, matching on the year in row 1 of each column. For example, C25: =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) Ex 1 - LBO!C17 is the only one with a fixed year. The others look up the year from a header cell, so they'll update if the timeline changes.
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked by an LLM judge.- Names the 7 INDEX/MATCH cells: C17, P17 and C25:G25
Passed 20
Autosheet in Excel Opus 5.5 · Medium
Passed13s · 6¢
I'll scan every sheet's formulas for INDEX and MATCH. Find INDEX/MATCH formulas I checked the formulas on every sheet. 7 cells use INDEX(MATCH), and they're on 2 sheets. No other formula in the workbook uses INDEX or MATCH. Ex 1 - LBO C17: pulls row 40 (Adj. EBITDA) from Ex 4 - Organic Operating Model, matching on the year 2025, which is typed directly into the formula: =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) P17: pulls row 18 (Revenue) from Ex 4 - Organic Operating Model, matching on the year in P1: =INDEX('Ex 4 - Organic Operating Model'!C18:K18,MATCH(P1,'Ex 4 - Organic Operating Model'!C1:K1,0)) Ex 3 - PF P&L C25:G25 (Amdocs Adj. EBITDA, 2026P–2030P): these five cells pull row 40 from Ex 4 - Organic Operating Model, matching on the year in row 1 of each column. For example, C25: =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) Ex 1 - LBO!C17 is the only one with a fixed year. The others look up the year from a header cell, so they'll update if the timeline changes.
Autosheet in Excel GPT-6 Astra · Low
Passed8s · 9¢
I’ll scan the workbook’s formulas for cells that use both INDEX and MATCH. Find INDEX and MATCH formulas across workbook 7 cells use formulas containing both INDEX and MATCH: Ex 1 - LBO C17, P17 Ex 3 - PF P&L C25:G25 No other matching formulas were found in the workbook.
Autosheet in Sheets Opus 5.5 · Medium
Passed14s · 64¢
I found 7 cells across 2 sheets that use INDEX/MATCH formulas. I checked the formulas on every sheet, and no other sheet has any. Ex 1 - LBO (2 cells) - C17: Entry EBITDA for FY2025. It looks up row 40 of the operating model, and the year 2025 is typed into the formula. Formula =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) - P17: Total Revenue for 2025A. It looks up row 18, using the year in P1. Formula =INDEX('Ex 4 - Organic Operating Model'!C18:K18,MATCH(P1,'Ex 4 - Organic Operating Model'!C1:K1,0)) Ex 3 - PF P&L (5 cells) - C25:G25: EBITDA for each forecast year. Each cell looks up row 40, using the year in row 1 (C1 to G1). For example, C25: Formula =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) All 7 pull data from 'Ex 4 - Organic Operating Model' by matching a year in its header row C1:K1. 'Ex 1 - LBO'!C17 is the only one with the year typed in (2025) instead of taken from a cell, so it won't update if the timeline moves.
Autosheet in Excel Sonnet 5.5 · Medium
Passed6s · 3¢
I'll scan every sheet for formulas that use INDEX and MATCH. Find INDEX/MATCH formulas INDEX(MATCH) formulas appear in 7 cells across 2 sheets: Ex 3 - PF P&L C25:G25. They pull from 'Ex 4 - Organic Operating Model' by matching the year in row 1. Ex 1 - LBO C17 and P17. I only checked for formulas that contain both INDEX( and MATCH(, so XLOOKUP and other lookup types aren't included.
Claude in Excel Opus 5.5 · High
Passed15s · 14¢
I didn't change anything in the workbook. The scan only read formulas, and no values, formulas or formatting were changed. The list above comes straight from that read. It covered the used range of all 14 sheets, and the formulas quoted are as they appear in the workbook. I didn't check the values those 7 cells currently return. I can do that if you want to confirm they're finding matches and not showing #N/A.
Autosheet in Excel Haiku 5.5 · High
Passed10s · 0.2¢
I'll scan every sheet's formulas for INDEX and MATCH together. Find INDEX(MATCH) formulas across workbook Seven cells use INDEX(MATCH), all of them on two sheets: Ex 1 - LBO C17 and P17 Ex 3 - PF P&L C25 through G25 The cells all follow the same pattern: =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) uses a hardcoded year, MATCH(2025, ...), and matches against P1.
Claude in Sheets Opus 5.5 · Medium
Passed21s · 6¢
I scanned the formulas on all 14 tabs. Seven cells use INDEX(MATCH), and all of them pull a row from Ex 4 - Organic Operating Model, matching on the year header row (C1:K1). No other lookup functions turned up (VLOOKUP, HLOOKUP, XLOOKUP or LOOKUP). Ex 1 - LBO - C17 pulls row 40 for the year 2025, which is typed directly into the formula. - P17 pulls row 18 for the year in P1. Ex 3 - PF P&L - C25:G25 (5 cells) use the same formula filled across. Each pulls row 40 for the year in its own header cell, C1 to G1. One thing to check: C17 has the year 2025 typed into its formula, while the others take the year from a header cell. If the timeline moves, C17 won't update on its own. Pointing it at a header or input cell would fix that.
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed29s · N/A
Seven cells in the workbook use INDEX(MATCH). Each one pulls a row from 'Ex 4 - Organic Operating Model' and finds the right column by matching a year against that sheet's header row ( C1:K1 ). Ex 1 - LBO (2 cells) Cell Formula C17 =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) P17 =INDEX('Ex 4 - Organic Operating Model'!C18:K18,MATCH(P1,'Ex 4 - Organic Operating Model'!C1:K1,0)) =INDEX('Ex 4 - Organic Operating Model'!C18:K18,MATCH(P1,'Ex 4 - Organic Operating Model'!C1:K1,0)) Ex 3 - PF P&L (5 cells, C25:G25) Cell Formula C25 =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) D25 same formula, matching on D1 same formula, matching on D1 E25 same formula, matching on E1 same formula, matching on E1 F25 same formula, matching on F1 same formula, matching on F1 G25 same formula, matching on G1 same formula, matching on G1 A few notes: Ex 1 - LBO!C17 has the year 2025 typed directly into the formula. Every other cell takes the year from a header cell (row 1). Most of these cells pull row 40 of the operating model. Only Ex 1 - LBO!P17 pulls row 18. No other sheet uses INDEX, MATCH or any similar lookup function ( XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, XMATCH, OFFSET ).
Autosheet in Excel GPT-6.1 Sol · Medium
Passed10s · 8¢
I’ll scan the workbook’s formulas for cells that use both INDEX and MATCH, then list their locations. Find INDEX MATCH formulas across workbook 7 cells use formulas containing both INDEX and MATCH: Ex 1 - LBO C17, P17 Ex 3 - PF P&L C25:G25
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed41s · N/A
Seven cells use INDEX(MATCH), across two tabs. Each one looks up a row from Ex 4 - Organic Operating Model and uses MATCH to pick the year column from its header row (C1:K1). Tab Cell(s) Formula Ex 1 - LBO C17 =INDEX('Ex 4 - Organic Operating Model'!C40:K40, MATCH(2025, 'Ex 4 - Organic Operating Model'!C1:K1, 0)) Ex 1 - LBO C17 =INDEX('Ex 4 - Organic Operating Model'!C40:K40, MATCH(2025, 'Ex 4 - Organic Operating Model'!C1:K1, 0)) Ex 1 - LBO P17 =INDEX('Ex 4 - Organic Operating Model'!C18:K18, MATCH(P1, 'Ex 4 - Organic Operating Model'!C1:K1, 0)) Ex 1 - LBO P17 =INDEX('Ex 4 - Organic Operating Model'!C18:K18, MATCH(P1, 'Ex 4 - Organic Operating Model'!C1:K1, 0)) Ex 3 - PF P&L C25:G25 (5 cells) =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40, MATCH(C1, 'Ex 4 - Organic Operating Model'!$C$1:$K$1, 0)). The same formula is copied across, with the year cell moving to D1, E1, F1 and G1. Ex 3 - PF P&L C25:G25 (5 cells) =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40, MATCH(C1, 'Ex 4 - Organic Operating Model'!$C$1:$K$1, 0)). The same formula is copied across, with the year cell moving to D1, E1, F1 and G1. Hardcoded year: in Ex 1 - LBO!C17 the year 2025 is typed into the formula instead of pointing to a cell. P17 and the Ex 3 cells point to a year cell instead. Other lookup types: none of these cells use XMATCH or a two-way INDEX/MATCH/MATCH. Other tabs: the remaining tabs have no INDEX/MATCH formulas. The scan reported checking 15 tabs but named only 14, so one tab may not have been checked. I can re-scan it if you need certainty. The scan only read the workbook; nothing was changed.
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed41s · N/A
Autosheet inspected all 13 tabs in your Google spreadsheet and found 7 cells using INDEX/MATCH formulas, across 2 tabs. Cells containing INDEX/MATCH Sheet Cell Lookup reference Source range Ex 1 - LBO C17 2025 Row 40 Ex 1 - LBO P17 P1 Row 18 Ex 3 - PF P&L C25 C1 Row 40 Ex 3 - PF P&L D25 D1 Row 40 Ex 3 - PF P&L E25 E1 Row 40 Ex 3 - PF P&L F25 F1 Row 40 Ex 3 - PF P&L G25 G1 Row 40 All seven formulas retrieve values from the Ex 4 - Organic Operating Model tab. Example formulas Ex 1 - LBO!C17 =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) Ex 3 - PF P&L!C25 =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) Summary Cells using INDEX/MATCH 7 Ex 1 - LBO: 2 Ex 3 - PF P&L: 5 The other 11 tabs contain no INDEX/MATCH formulas. Verification: All seven use the INDEX(range, MATCH(...)) pattern. No spreadsheet cells were modified. Open your Google spreadsheet
Autosheet in Sheets Haiku 5.5 · High
Passed21s · 7¢
Seven cells in the workbook use INDEX(MATCH): - Ex 1 - LBO: C17 and P17. C17 hardcodes the year 2025 in its MATCH, while P17 looks up the year in P1. - Ex 3 - PF P&L: C25:G25. These pull Amdocs Adj. EBITDA from Ex 4 - Organic Operating Model by matching each column's year in row 1. No other sheets contain INDEX(MATCH) formulas.
ChatGPT in Excel GPT-6 Astra · Medium
Passed14s · 36¢
I’ll scan the workbook’s formulas for INDEX with MATCH. Found 7 cells using INDEX(...MATCH(...)) formulas: - C17 — matches 2025 against the Organic Operating Model’s year headers and returns row 40. (Ex 1 - LBO!C17) - P17 — matches the year in P1 and returns row 18 from the Organic Operating Model. (Ex 1 - LBO!P17) - C25:G25 — five cells matching each column’s year in row 1 and returning row 40 from the Organic Operating Model. (Ex 3 - PF P&L!C25:G25) All seven use exact-match MATCH(...,0). No workbook changes made.
Claude in Excel Haiku 5.5 · High
Passed12s · 0.5¢
There are 7 cells in this workbook that use INDEX(MATCH), across two sheets: - Ex 1 - LBO: C17 and P17. C17 hardcodes the year as MATCH(2025, …) instead of referencing a header cell, unlike P17, which uses MATCH(P1, …). - Ex 3 - PF P&L: C25:G25. Each cell looks up its column header in row 1 against the Organic Operating Model sheet. I scanned every sheet's formulas. The two open peer files (Book1-recovered-20261113 and chart_histogram_output) are separate workbooks, so I didn't check them. I didn't write anything to the workbook in this exchange; my last turn only read formulas. To be sure the list is still accurate, I re-read the seven cells. All seven still contain INDEX(MATCH) formulas, and the formulas match what I reported: - Ex 1 - LBO: C17 and P17 (C17 hardcodes 2025 inside MATCH; P17 references P1) - Ex 3 - PF P&L: C25:G25 I did not re-read the other sheets, but my earlier scan covered every sheet in this workbook.
Claude in Sheets Haiku 5.5 · High
Passed21s · 1¢
The workbook has 7 cells that use INDEX(MATCH). All are on two sheets: - Ex 1 - LBO: C17 and P17. C17 hardcodes the year 2025 in the MATCH, while P17 matches against the header in P1. - Ex 3 - PF P&L: C25 through G25. Each pulls from 'Ex 4 - Organic Operating Model' row 40, matching the year header in row 1 of this sheet. I scanned every sheet's used range for formulas containing both INDEX and MATCH. I didn't check for other lookup functions such as XLOOKUP or VLOOKUP. I made no changes to the workbook.
Autosheet in Excel GPT-6 Luna · High
Passed15s · 0.4¢
I’m scanning the used ranges across all workbook tabs for formulas that contain both INDEX and MATCH. Row count: unknown. Using BATCH_SIZE=500 with sync() per batch. Find INDEX/MATCH formulas across workbook Found 7 cells with formulas containing both INDEX and MATCH: Ex 1 - LBO: C17, P17 Ex 3 - PF P&L: C25:G25 No other matching formulas were found in the workbook.
ChatGPT + Drive MCP GPT-6 · Medium
Passed28s · N/A
I checked all 14 tabs in the Google spreadsheet. I found 7 cells containing INDEX combined with MATCH, across 2 worksheets. Worksheet Cells Count Ex 1 - LBO C17, P17 2 Ex 3 - PF P&L C25, D25, E25, F25, G25 5 Total 7 Formula examples Ex 1 - LBO!C17 =INDEX('Ex 4 - Organic Operating Model'!C40:K40,MATCH(2025,'Ex 4 - Organic Operating Model'!C1:K1,0)) Ex 3 - PF P&L!C25 =INDEX('Ex 4 - Organic Operating Model'!$C40:$K40,MATCH(C1,'Ex 4 - Organic Operating Model'!$C$1:$K$1,0)) All seven formulas reference the Ex 4 - Organic Operating Model worksheet. The other 12 worksheets contain no formulas combining INDEX and MATCH. The spreadsheet was not modified.
ChatGPT in Excel GPT-6 Luna · High
Passed13s · 0.4¢
I’ll scan formulas across every populated sheet and list matching cell references. I found INDEX(MATCH()) formulas in: - Ex 1 - LBO: C17, P17 (Ex 1 - LBO!C17, Ex 1 - LBO!P17) - Ex 3 - PF P&L: C25:G25 (Ex 3 - PF P&L!C25:G25)
ChatGPT in Sheets GPT-6 Astra · Medium
Passed33s · 30¢
I’ll search the workbook for formulas combining INDEX and MATCH. Thought for a few seconds Found 7 cells using INDEX(...,MATCH(...)) formulas: Ex 1 - LBO: C17 and P17. Ex 1 - LBOC17 Ex 1 - LBOP17 Ex 3 - PF P&L: C25, D25, E25, F25, and G25. Ex 3 - PF P&LC25:G25 All reference Ex 4 - Organic Operating Model and use exact-match MATCH(...,0) to locate the relevant year. No workbook changes made.
ChatGPT in Sheets GPT-6 Luna · High
Passed30s · 0.3¢
I found 7 cells using an INDEX(MATCH(...)) formula: Ex 1 - LBO: C17, P17 Ex 1 - LBOC17 Ex 1 - LBOP17 Ex 3 - PF P&L: C25 Ex 3 - PF P&LC25:G25
Failed 2
Copilot in Excel Auto
Failed19s · N/A
I'm not able to answer that. What else can I do for you?
Why it failed: The assistant stated it was unable to answer rather than identifying the 7 cells (Ex 1 - LBO: C17, P17 and Ex 3 - PF P&L: C25:G25).
Gemini in Sheets Auto
Failed29s · N/A
After a thorough inspection across all tables in this workbook, no INDEX(MATCH) formulas or text references were found. Key Observations: Cell Values vs. Formulas: The data available in the current context represents evaluated cell values (calculated outputs) rather than the underlying cell formula text (such as formulas starting with =). Tables Inspected: Ex 1 - LBO Ex 2 - Valuation Bridge Ex 3 - PF P&L Ex 4 - Organic Operating Model Ex 5 - M&A Ex 6 - Amdocs Historical M&A Ex 7 - SOFR Ex 8 - Public Comps Ex 9 - Transaction Comps Ex 10 - Balance Sheet Ex 11 - Income Statement Ex 12 - Cash Flow Statement Raw Data Support Because formula strings are not stored or exposed in the underlying table data, specific formula constructs like INDEX(MATCH) cannot be identified directly from the values alone.
Why it failed: The assistant did not identify the 7 cells using INDEX(MATCH) formulas (Ex 1 - LBO: C17, P17 and Ex 3 - PF P&L: C25:G25), instead asserting that no formulas were found.