All AutosheetBench tasks

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 and starting spreadsheet

Task files

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
BCDEFGHIJK
1
2
3Master Control
4Company NameAmdocs
5TickerNASDAQ: DOX
6Units in $Millions
7Units Converter1,000.0
8Circ1
9Operating Case1
10M&A Switch1
11M&A Purchase EBITDA Multiple14.2x
12
13Amdocs - ControlAmdocs - Forecast Drivers
14
15Acquisition AssumptionsSources & UsesPF P&L Drivers
16Entry Valuation MetricEBITDASources2026P2027P2028P
17Entry EBITDA - FY2025$802.4Expected Revolver Draw$0.0Revenue Growth4.0%5.2%6.4%
18Entry EBITDA Multiple14.2xSenior Secured TLB$3,209.6Base Case4.0%5.2%6.4%
19Exit Valuation MetricEBITDAPIK Debt$0.0Upside Case4.0%5.2%6.4%
20Exit EBITDA Multiple14.2xManagement Rollover$199.3Downside Case4.0%5.2%6.4%
21Amortization of Financing Fees–Sponsor Equity$8,101.8

Ex 2 - Valuation Bridge

Starting sheet · rows 2–8 of 35
BC
2Amdocs (DOX) - Valuation Bridge
3Starting Equity$8,301.2
4Transaction Fees($114.0)
5EBITDA Growth$8,146.5
6Debt Paydown$3,340.3
7Multiple Expansion$0.0
8Exit Equity$19,673.9

Ex 3 - PF P&L

Starting sheet · rows 1–21 of 30
BCDEFGHI
120262027202820292030
2
3
4Case1
5M&A Switch1
6
7Amdocs - PF P&L
8
9PF P&L
10
11($ in millions)2026P2027P2028P2029P2030P26P - '30P CAGR
12Revenue
13Amdocs$4,714.3$4,959.5$5,276.9$5,688.5$6,211.87.1%
14M&A$0.0$0.0$0.0$0.0$0.0
15Total Revenue$4,714.3$4,959.5$5,276.9$5,688.5$6,211.87.1%
16% YoY Growth4.0%5.2%6.4%7.8%9.2%
17
18Gross Profit
19Amdocs$1,675.8$1,842.3$2,044.6$2,306.5$2,630.511.9%
20M&A$0.0$0.0$0.0$0.0$0.0
21Total Gross Profit$1,675.8$1,842.3$2,044.6$2,306.5$2,630.511.9%

Ex 4 - Organic Operating Model

Starting sheet · rows 1–21 of 42 and columns B–K of 31
BCDEFGHIJK
1202220232024202520262027202820292030
2
3
4Case1
5
6Amdocs - Organic Operating Model
7
8Active Case
9($ in millions)2022A2023A2024A2025A2026P2027P2028P2029P2030P
10
11P&L
12Managed Services Arrangements2,755.52,856.82,904.92,996.0
13Others1,821.22,030.92,100.11,537.0
14Total Revenue$4,576.7$4,887.8$5,005.0$4,533.0
15
16Recurring Software1,373.01,564.11,651.61,541.21,602.91,822.62,084.42,403.42,795.3
17Services3,203.73,323.73,353.32,991.83,111.53,136.93,192.53,285.13,416.5
18Total 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 Growth6.8%2.4%(9.4%)4.0%5.2%6.4%7.8%9.2%
20
21Revenue Drivers

Ex 5 - M&A

Starting sheet · rows 1–20 of 84 and columns B–K of 27
BCDEFGHIJK
11234512
22026202720282029203020262027
3
4Case3
5
6Amdocs - 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
11Active CaseBase Case
12($ in millions)Year 1Year 2Year 3Year 4Year 5($ in millions)Year 1Year 2
13Revenue$30.0$31.8$33.7$35.7$37.9Revenue$30.0$31.8
14% YoY Growth6.0%6.0%6.0%6.0%% YoY Growth6.0%
15
16Gross Profit$21.0$22.3$23.6$25.0$26.5Gross Profit$21.0$22.3
17% of Revenue70.0%70.0%70.0%70.0%70.0%% of Revenue70.0%70.0%
18
19EBITDA$6.9$7.3$7.8$8.2$8.7EBITDA$7.5$8.0
20% of Revenue23.0%23.0%23.0%23.0%23.0%% of Revenue25.0%25.0%

Support >>

Starting sheet
A
1

Ex 6 - Amdocs Historical M&A

Starting sheet · columns B–J of 249
BCDEFGHIJ
2Amdocs - Historical M&A, 10 Years
3
4Transaction Summary
5($ in miillions)
6Announced DateClosed DateTransaction TypeRoleTargetBuyer/InvestorsSellersSizeRevenue
7Nov-07-2023Nov-02-2023Merger/AcquisitionBuyerAstadia Inc.Amdocs Limited (NasdaqGS:DOX)New Harbour Partners LLC; Spring Lake Equity Partners LLC$75.0-
8Nov-07-2023Aug-22-2023Merger/AcquisitionBuyerProCom Consulting, Inc.Amdocs Limited (NasdaqGS:DOX)$37.0$2.2
9May-10-2023Jul-03-2023Merger/AcquisitionBuyerService assurance business of TEOCO CorporationAmdocs Limited (NasdaqGS:DOX)TEOCO Corporation$90.0-
10Nov-30-2021Nov-15-2021Merger/AcquisitionBuyerDevOpsGroup Limited (nka:Sourced Group Cloud Services Limited)Amdocs Limited (NasdaqGS:DOX)Business Growth Fund Limited$26.0-
11May-12-2021Mar-15-2021Merger/AcquisitionBuyerSourced Group Inc.Amdocs Limited (NasdaqGS:DOX)Comerica Bank, Banking Investments; HSBC Ventures; Round 13 Capital, Inc.$75.0-
12Jul-23-2020Aug-11-2020Merger/AcquisitionBuyerOpenet Telecom LimitedAmdocs Limited (NasdaqGS:DOX)Balderton Capital (UK) LLP; Cipio Partners; Cross Atlantic Capital Partners LLC; Enterprise Ireland Seller Funds: Taggia$180.0$63.0
13Aug-07-2019Aug-07-2019Merger/AcquisitionBuyerTelecom Technology Services, Inc.Amdocs Limited (NasdaqGS:DOX)$50.0-
14Feb-27-2018-Merger/AcquisitionBuyerUXP Systems Inc.Amdocs Limited (NasdaqGS:DOX)$80.0-
15Jan-30-2018Feb-22-2018Merger/AcquisitionBuyerVubiquity, 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
16Jan-30-2018Dec-31-2017Merger/AcquisitionBuyerprojekt202, LLC.Amdocs Limited (NasdaqGS:DOX)$54.0$32.1
17Sep-14-2016Sep-14-2016Merger/AcquisitionBuyerPontis, 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…--
18Sep-14-2016Sep-14-2016Merger/AcquisitionBuyerBrite:Bill LimitedAmdocs Limited (NasdaqGS:DOX)Delta Partners Limited; Enterprise Ireland; Investec Ventures Ireland Ltd Seller Funds: The Harcourt venture Fund Limited Partnership-$40.8
19Feb-03-2016Jan-31-2016Merger/AcquisitionBuyercVidya 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
BCDE
2SOFR - Market Projections
3
4SOFR Market Projections
5Reset Date1-month Term SOFR3-month Term SOFR1-Month ISDA SOFR
621/11/20253.95%3.88%4.19%
722/12/20253.80%3.76%3.90%
821/01/20263.71%3.65%3.90%
923/02/20263.67%3.53%3.79%
1023/03/20263.57%3.47%3.79%
1121/04/20263.49%3.41%3.79%
1221/05/20263.43%3.34%3.43%
1322/06/20263.32%3.26%3.43%
1421/07/20263.24%3.19%3.43%
1521/08/20263.19%3.14%3.20%
1621/09/20263.12%3.08%3.20%
1721/10/20263.08%3.03%3.20%
1823/11/20263.00%3.01%3.12%
1921/12/20263.00%3.00%3.12%
2021/01/20273.00%3.00%3.12%
2122/02/20273.00%3.01%3.12%
2222/03/20273.00%3.00%3.12%

Ex 8 - Public Comps

Starting sheet · rows 2–22 of 36
BCDEF
2Amdocs - Public Comparables Analysis
3
4EV/Revenue
5Company Name2025 Avg.2024 Avg.2023+ Max2023+ Min
6Amdocs (NASDAQ: DOX)2.2x2.1x2.5x1.8x
7CSG (NASDAQ: CSGS)1.8x1.6x2.0x1.4x
8Lumine (TSX: LMN)12.0x13.2x24.2x2.8x
9NetScout (NASDAQ: NTCT)1.5x1.5x2.7x1.2x
10Optiva (TSX: OPT)2.3x2.3x2.7x1.7x
11Radcom (NASDAQ: RDCM)1.8x1.3x2.1x0.8x
12Subex (BSE: 532348)2.6x5.5x9.0x3.7x
13Synchronoss (NASDAQ: SNCR)1.7x1.8x2.1x1.1x
14Tecnotree (HLSE: TEM1V)1.0x1.1x2.5x0.6x
15Average3.0x3.4x5.5x1.7x
16Median1.8x1.8x2.5x1.4x
17Max12.0x13.2x24.2x3.7x
18Min1.0x1.1x2.0x0.6x
19
20EV/EBITDA
21Company Name2025 Avg.2024 Avg.2023+ Max2023+ Min
22Amdocs (NASDAQ: DOX)10.2x10.5x11.5x9.2x

Ex 9 - Transaction Comps

Starting sheet · rows 2–22 of 63
BCDEFG
2Selected Transactions Analysis
3($ in millions)
4DateTargetTypeTotal EVDebt / EBITDATEV / EBITDA
52024AssetMark Financial Holdings, Inc.SaaS-0.1x-
62023Blackbaud, Inc. (NasdaqGS:BLKB)SaaS3,691.83.6x12.3x
72020Engineering Ingegneria Informatica S.p.A.SaaS-8.3x-
82024Envestnet, Inc.SaaS-6.4x22.9x
92024Everbridge, Inc.SaaS-34.1x-
102024Exclusive Networks SASaaS-3.2x10.3x
112024Fuji Soft IncorporatedSaaS-1.8x22.7x
122024Instructure Holdings, Inc.SaaS-5.5x20.5x
132025Iress Limited (ASX:IRE)SaaS1,163.02.8x21.3x
142025Jamf Holding Corp. (NasdaqGS:JAMF)SaaS1,956.020.6x-
152025MeridianLink, Inc.SaaS-8.6x-
162021Mphasis Limited (BSE:526299)SaaS5,759.30.8x18.9x
172025Sapiens International Corporation N.V. (NasdaqGS:SPNS)SaaS2,381.60.5x-
182025SolarWinds CorporationSaaS-4.6x14.5
192022VNET Group, Inc. (NasdaqGS:VNET)SaaS5,680.59.0x10.4x
202024WM Technology, Inc. (NasdaqGS:MAPS)SaaS127.81.0x3.9x
21Average2,965.76.9x15.8x
22Median2,381.64.1x16.7x

Raw Data >>

Starting sheet
A
1

Ex 10 - Balance Sheet

Starting sheet · rows 2–22 of 32
BCDEF
2Amdocs - Condensed Consolidated Balance Sheets
3($ in thousands)
4As of
5September 30, 2025September 30, 2024
6ASSETS
7Current assets:
8Cash and cash equivalents324,999346,085
9Short-term interest-bearing investments—168,242
10Accounts receivable, net, including unbilled935,7511,028,357
11Prepaid expenses and other current assets331,387228,498
12Total current assets1,592,1371,771,182
13Property and equipment, net768,557755,601
14Lease assets182,088149,254
15Goodwill and other intangible assets, net3,046,9623,005,637
16Other noncurrent assets660,086704,468
17Total assets$6,249,830$6,386,142
18
19LIABILITIES AND SHAREHOLDERS’ EQUITY
20Current liabilities
21Accounts payable, accruals and other1,201,2061,315,679
22Lease liabilities38,72539,983

Ex 11 - Income Statement

Starting sheet · rows 1–21 of 28 and columns B–K of 12
BCDEFGHIJK
1
2Amdocs - Consolidated Statements of Income
3($ in thousands)
4Three months ended September 30,Fiscal year ended September 30,
52025 (a)20242025 (a)2024
6Revenue$1,150,218$1,263,882$4,532,913$5,004,989
7Operating expenses:
8Cost of revenue719,878824,8882,811,3333,249,598
9Research and development87,86590,069340,845360,798
10Selling, general and administrative121,807138,705506,108572,845
11Amortization of purchased intangible assets and other14,28714,33362,42462,052
12Restructuring charges73,75683,21380,539131,088
131,017,5931,151,2083,801,2494,376,381
14Operating income132,625112,674731,664628,608
15Interest and other expense, net(11,843)(9,237)(38,422)(37,537)
16Income before income taxes120,782103,437693,242591,071
17Income taxes23,66816,261125,47394,750
18
19Net income$97,114$87,176$567,769$496,321
20Net income attributable to noncontrolling interests$787$735$3,065$3,124
21Net 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
BCDEFG
1
2Amdocs - Consolidated Statements of Cash Flows
3($ in thousands)
4Year Ended September 30,
520252024
6Cash Flow from Operating Activities:
7Net income$567,769$496,321
8Reconciliation of net income to net cash provided by operating activities:
9Depreciation, amortization and impairment195,435195,234
10Amortization of debt issuance cost608596
11Equity-based compensation expense104,864104,540
12Deferred income taxes20,291(45,673)
13Loss from short-term interest-bearing investments3,4875,576
14Net changes in operating assets and liabilities, net of amounts acquired:
15Accounts receivable, net79,606(104,413)
16Prepaid expenses and other current assets(55,061)(8,478)
17Other noncurrent assets(15,445)(2,250)
18Lease assets and liabilities, net3,221(6,485)
19Accounts payable, accrued expenses and accrued personnel(77,041)216,324
20Deferred revenue8,172(60,332)
21Income taxes payable, net(15,109)(47,241)

A passing output

Autosheet in Excel · Opus 5.5
Transcript excerptExpected answer
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.

How each AI configuration did

20 of 22 passRun files
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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
Transcript excerptExpected answer
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
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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¢
Transcript excerptExpected answer
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
Transcript excerptExpected answer
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
Transcript excerptExpected answer
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.