Spreadsheet: 838065d1690660729-vlookup-with-row-and-column-values-vlookup-with-year-solution-
Sheet: Sheet1

Store | Year | Line1a | Line1b | Line1c | Line2 | [NAME] | Line4 | Line5 | Line6 | Line7 | Line8 | Line9 | [NAME] | Line11 | Line12 | Line13 | Line14 | Line15 | Line16 | Line17 | Line18 | Line19 | Line20 | [NAME] | Schk_Line1 | Schk_Line2 | Schk_Line3a | Schk_Line3b | Schk_Line3c | Schk_Line4 | Schk_Line5a | Schk_Line5b | Schk_Line6 | Schk_Line7 | Schk_Line8a | Schk_Line8b | Schk_Line8c | Schk_Line9 | Schk_Line10 | Schk_Line11 | Schk_Line12a | Schk_Line12b | Schk_Line12c | Schk_Line12d | [NAME] | Schk_Line13b | Schk_Line13c | Schk_Line13d | Schk_Line13e | Schk_Line13f | Schk_Line13g | Schk_Line15a | Schk_Line15b | Schk_Line15c | Schk_Line15d | Schk_Line15e | Schk_Line15f | Schk_Line16a | Schk_Line16b | Schk_Line16c | Schk_Line16d | Schk_Line16e | Schk_Line16f | Schk_Line17a | Schk_Line17b | Schk_Line17c | Schk_Line18 | [NAME] | SchM1_Line2a | [NAME] | SchM1_Line3a | SchM1_Line3b | SchM1_Line3c | SchM1_Line4 | SchM1_Line5a | SchM1_Line5b | SchM1_Line6a | SchM1_Line6b | SchM1_Line7 | SchM1_Line8 | SchM2_Line1a | SchM2_Line1b | SchM2_Line1c | SchM2_Line1d | SchM2_Line2 | SchM2_Line3a | SchM2_Line3d | SchM2_Line4a | SchM2_Line5a | SchM2_Line5d | SchM2_Line6a | SchM2_Line6b | SchM2_Line6c | SchM2_Line6d | SchM2_Line7a | SchM2_Line7b | SchM2_Line7c | SchM2_Line7d | SchM2_Line8a | SchM2_Line8b | SchM2_Line8c | SchM2_Line8d | SchL_Line1b | SchL_Line1d | SchL_Line2aa | SchL_Line2ac | SchL_Line2ba | SchL_Line2bb | SchL_Line2bc | SchL_Line2bd | SchL_Line3b | SchL_Line3d | SchL_Line4b | SchL_Line4d | SchL_Line5b | SchL_Line5d | SchL_Line6b | SchL_Line6d | SchL_Line7b | SchL_Line7d | SchL_Line8b | SchL_Line8d | [NAME] | SchL_Line9d | SchL_Line10aa | SchL_Line10ac | SchL_Line10ba | SchL_Line10bb | SchL_Line10bc | SchL_Line10bd | [NAME] | SchL_Line11ac | SchL_Line11ba | SchL_Line11bb | SchL_Line11bc | SchL_Line11bd | SchL_Line12b | SchL_Line12d | SchL_Line13aa | SchL_Line13ac | SchL_Line13ba | SchL_Line13bb | SchL_Line13bc | SchL_Line13bd | SchL_Line14b | SchL_Line14d | SchL_Line15b | SchL_Line15d | SchL_Line16b | SchL_Line16d | SchL_Line17b | SchL_Line17d | SchL_Line18b | [NAME] | SchL_Line19b | SchL_Line19d | SchL_Line20b | SchL_Line20d | SchL_Line21b | SchL_Line21d | SchL_Line22b | SchL_Line22d | SchL_Line23b | SchL_Line23d | SchL_Line24b | SchL_Line24d | SchL_Line25b | SchL_Line25d | SchL_Line26b | SchL_Line26d | SchL_Line27b | SchL_Line27d
Fayetteville | 2020 | 1181005 | 0 | 1181005 | 331533 | 849472
Fayetteville | 2021
Fayetteville | 2022
 |  |  | 2020 | 2021 | 2022
 | Line1a | 1a Gross receipts or sales
 | Line1b | b Returns and allowances
 | Line1c | C Balance. Subtract line 1 b from line 1 a
 | Line2 | Cost of goods sold (attach Form 1125-A)
 | [NAME] | Gross profit. Subtract line 2 from line 1 c
 | Line4 | Net gain (loss)
 | Line5 | Other income (loss)
 | Line6 | Total income {loss)
 | Line7 | Compensation of officers
 | Line8 | Salaries and wage
 | Line9 | Repairs and maintenance .
 | [NAME] | Bad debts
 | Line11 | Rents
 | Line12 | Taxes and licenses
 | Line13 | Interest
 | Line14 | Depreciation from Form 4562
 | Line15 | Depletion
 | Line16 | Advertising
 | Line17 | Pension, profit-sharing, etc., plans
 | Line18 | Employee benefit programs
 | Line19 | Other deductions (attach statement)
 | Line20 | Total deductions
 | [NAME] | Ordinary business income
 | Schk_Line1 | Ordinary business income (loss) (page 1, line 21) .
 | Schk_Line2 | Net rental real estate income (loss) (attach Form 8825)
 | Schk_Line3a | Other gross rental income (loss)
 | Schk_Line3b | Expenses from other rental activities (attach statement)
 | Schk_Line3c | Other net rental income (loss). Subtract line 3b from line 3a
 | Schk_Line4 | Interest income
 | Schk_Line5a | Dividends: a Ordinary dividends
 | Schk_Line5b | b Qualified dividends
 | Schk_Line6 | Royalties
 | Schk_Line7 | Net short-term capital gain (loss) (attach [NAME] D (Form 1120-S))
 | Schk_Line8a | Net long-term capital gain (loss) (attach [NAME] D (Form 1120-S))
 | Schk_Line8b | Collectibles (28%) gain (loss
 | Schk_Line8c | Unrecaptured section 1250 gain (attach statement)
 | Schk_Line9 | Net section 1231 gain (loss) (attach Form 4797)
 | Schk_Line10 | Other income (loss) (see instructions)
 | Schk_Line11 | Section 179 deduction (attach Form 4562)
 | Schk_Line12a | Charitable contributions
 | Schk_Line12b | Investment interest expense
 | Schk_Line12c | Section 59(e)(2) expenditures
 | Schk_Line12d | Other deductions (see instructions)
 | [NAME] | Low-income housing credit (section 420)(5))
 | Schk_Line13b | Low-income housing credit (other)
 | Schk_Line13c | Qualified rehabilitation expenditures (rental real estate) (attach Form 3468, if applicable)
 | Schk_Line13d | Other rental real estate credits (see instructions)
 | Schk_Line13e | Other rental credits (see instructions)
 | Schk_Line13f | Biofuel producer credit (attach Form 6478)
 | Schk_Line13g | Other credits (see instructions)
 | Schk_Line15a | Post-1986 depreciation adjustment
 | Schk_Line15b | Adjusted gain or loss
 | Schk_Line15c | Depletion (other than oil and gas)
 | Schk_Line15d | Oil, gas, and geothermal properties-gross income
 | Schk_Line15e | Oil, gas, and geothermal properties-deductions
 | Schk_Line15f | Other AMT items (attach statement)
 | Schk_Line16a | Tax-exempt interest income
 | Schk_Line16b | Other tax-exempt income
 | Schk_Line16c | Nondeductible expenses
 | Schk_Line16d | Distributions (attach statement if required) (see instructions)
 | Schk_Line16e | Repayment of loans from shareholders
 | Schk_Line16f | Foreion taxes paid or accrued
 | Schk_Line17a | Investment Income
 | Schk_Line17b | Investment Expense
 | Schk_Line17c | Dividend Distributions
 | Schk_Line17d | Other Items and amounts
 | Schk_Line18 | Income (loss) reconciliation
 | [NAME] | Net income (loss) per books
 | SchM1_Line2a | Income included on Schedule K not recorded on books
 | [NAME] | Expense recorded not included on [NAME]
 | SchM1_Line3a | Depriciation
 | SchM1_Line3b | Travel & entertainment
 | SchM1_Line4 | Add Line 1 through 3
 | SchM1_Line5a | Tax Exempt
 | SchM1_Line5b | Income recorded on books not included on [NAME]
 | SchM1_Line6a | Depriciation
 | SchM1_Line6b | Deductions included on Sch k
 | SchM1_Line7 | Add lines 5 and 6
 | SchM1_Line8 | Income (loss) [NAME] 18 (Subtract Line 7 from Line 14)
 | SchM2_Line1a | Balance at beginning of tax year
 | SchM2_Line1b | Balance at beginning of tax year
 | SchM2_Line1c | Balance at beginning of tax year
 | SchM2_Line1d | Balance at beginning of tax year
 | SchM2_Line2a | Ordinary income from page 1, line 21
 | SchM2_Line3a | Other Additions
 | SchM2_Line3d | Other Additions
 | SchM2_Line4a | Loss from Page1, Line 21
 | SchM2_Line5a | Other Deductions
 | SchM2_Line5d | Other Deductions
 | SchM2_Line6a | Combine lines 1 through 5
 | SchM2_Line6b | Combine lines 1 through 5
 | SchM2_Line6c | Combine lines 1 through 5
 | SchM2_Line6d | Combine lines 1 through 5
 | SchM2_Line7a | Distributions
 | SchM2_Line7b | Distributions
 | SchM2_Line7c | Distributions
 | SchM2_Line7d | Distributions
 | SchM2_Line8a | BalanceEnd of year Subtract Line 7 from 6
 | SchM2_Line8b | BalanceEnd of year Subtract Line 7 from 6
 | SchM2_Line8c | BalanceEnd of year Subtract Line 7 from 6
 | SchM2_Line8d | BalanceEnd of year Subtract Line 7 from 6
 | SchL_Line1b | Cash
 | SchL_Line1d | Cash
 | SchL_Line2aa | Trade Notes and accounts receivable
 | SchL_Line2ac | Trade Notes and accounts receivable
 | SchL_Line2ba | Less allowance for bad dedts
 | SchL_Line2bb
 | SchL_Line2bc | Less allowance for bad dedts
 | SchL_Line2bd
 | SchL_Line3b | Inventories
 | SchL_Line3d | Inventories
 | SchL_Line4b | US Government obligations
 | SchL_Line4d | US Government obligations
 | SchL_Line5b | Tax Exempt Securities
 | SchL_Line5d | Tax Exempt Securities
 | SchL_Line6b | Other Current Assets
 | SchL_Line6d | Other Current Assets
 | SchL_Line7b | Loans to Shareholders
 | SchL_Line7d | Loans to Shareholders
 | SchL_Line8b | Mortgage and rest estate loans
 | SchL_Line8d | Mortgage and rest estate loans
 | [NAME] | Other investments
 | SchL_Line9d | Other investments
 | SchL_Line10aa | Buildings and other depreciable assets
 | SchL_Line10ac | Buildings and other depreciable assets
 | SchL_Line10ba | Less accumulated depreciation
 | SchL_Line10bb
 | SchL_Line10bc | Less accumulated depreciation
 | SchL_Line10bd
 | [NAME] | Depletable assets
 | SchL_Line11ac | Depletable assets
 | SchL_Line11ba | Less accumulated depletion
 | SchL_Line11bb
 | SchL_Line11bc | Less accumulated depletion
 | SchL_Line11bd
 | SchL_Line12b | Land (net of any amortization)
 | SchL_Line12d | Land (net of any amortization)
 | SchL_Line13aa | Intangible assets (amotizable only)
 | SchL_Line13ac | Intangible assets (amotizable only)
 | SchL_Line13ba | Less accumulated amortization
 | SchL_Line13bb
 | SchL_Line13bc | Less accumulated amortization
 | SchL_Line13bd
 | SchL_Line14b | Other Assets
 | SchL_Line14d | Other Assets
 | SchL_Line15b | Total Assets
 | SchL_Line15d | Total Assets
 | SchL_Line16b | Accounts payable
 | SchL_Line16d | Accounts payable
 | SchL_Line17b | Mortgage notes payable less than 1 year
 | SchL_Line17d | Mortgage notes payable less than 1 year
 | SchL_Line18b | Other current lliabilities
 | [NAME] | Other current lliabilities
 | SchL_Line19b | Loan from shareholders
 | SchL_Line19d | Loan from shareholders
 | SchL_Line20b | Mortgage notes payable more than 1 year
 | SchL_Line20d | Mortgage notes payable more than 1 year
 | SchL_Line21b | Other Liabilities
 | SchL_Line21d | Other Liabilities
 | SchL_Line22b | Capital Stock
 | SchL_Line22d | Capital Stock
 | SchL_Line23b | Additional paid-in-capital
 | SchL_Line23d | Additional paid-in-capital
 | SchL_Line24b | [NAME]
 | SchL_Line24d | [NAME]
 | SchL_Line25b | Adjustments to shareholders equity
 | SchL_Line25d | Adjustments to shareholders equity
 | SchL_Line26b | Less cost f treasury stock
 | SchL_Line26d | Less cost f treasury stock
 | SchL_Line27b | Total liabilities and shareholders equity
 | SchL_Line27d | Total liabilities and shareholders equity