Forum Discussion
Vlookup Working but only till Row 55, at row 56 stops working
I have used Excel for many years, but have exhausted my knowledge on this one.
The worksheet that I am trying to fix is labeled "100.01". On "100.01" the first 55 instances are pulled from "Gen...
Tamara,
you have over complicated your model.
Make use of Excel tables, Pivot tables and Power Query.
Input would be "Chart of Accounts" and "General Ledger" (without the formulas). Output would be a Pivot table in "Financial Statement" layout.