
Closed
Posted
I need help fixing Excel spreadsheets, primarily broken formulas. The corrected formulas should mainly look up and combine information from other sheets. Key Tasks: - Fix broken formulas or incorrect calculations - Look up and combine information from other sheets - Work with different layouts requiring custom matching rules Ideal Skills: - Proficiency in Excel, especially with complex formulas - Experience in data integration from multiple sheets - Ability to create custom matching rules for different layouts - Attention to detail and problem-solving skills
Project ID: 40791445
75 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
75 freelancers are bidding on average $21 USD/hour for this job

Repairing broken Excel formulas and combining information across sheets is exactly where my expertise is strongest. I specialise in advanced Excel formulas, including VLOOKUP, INDEX/MATCH, SUMIFS and COUNTIFS, and can correct incorrect calculations while preserving the logic and structure of your workbook. My experience with Excel data analysis, processing, cleansing and formatting supports reliable work across different spreadsheet layouts. I can also apply custom matching rules, use Power Query for data integration, and leverage Excel Macros/VBA when repetitive or complex formula work requires automation. Careful spreadsheet organisation and problem-solving will help ensure the corrected formulas are accurate and consistent. I’m ready to put my Excel expertise to work repairing your spreadsheets and delivering dependable cross-sheet results.
$25 USD in 40 days
8.3
8.3

Hello, I can help identify and fix broken Excel formulas, including lookups across multiple sheets and combining data from worksheets with different layouts. I would first review the existing formulas, source data and matching criteria to determine whether the issues come from incorrect references, lookup logic, inconsistent data formats or calculation errors. Then I would correct the formulas and implement custom matching rules where standard lookups are insufficient. I have solid Excel experience and a strong troubleshooting background. I will test the corrected formulas against sample records and verify that the results remain reliable across the different layouts. Once I review the workbook and a few examples of the expected results, I can determine the most suitable formula-based approach.
$19.90 USD in 40 days
7.2
7.2

Hello, I hope you are doing well. I hold a master's degree in Statistics from a renowned university. I am a well experienced statistician/ data analyst. I have good command over Excel (please visit my profile to check reviews for my past projects). I have reviewed and understood your requirements, I can help you with this project. Please feel free to ask me, if you have any queries.
$20 USD in 40 days
6.3
6.3

I got you! I can help fix your Excel spreadsheets by repairing broken formulas, correcting calculations, and building reliable lookup/combine logic across sheets with different layouts. I’m ready to handle the project specifics, create custom matching rules where needed, and carefully verify results for accuracy. I’m young, a fast learner, and available 24/7. Get the demo first before you pay. A couple of quick questions: Are your formulas mainly using VLOOKUP/XLOOKUP/INDEX-MATCH, or do you also need Power Query? Also, what fields should be used as the matching keys when layouts differ between sheets? Let’s chat and discuss the answers so I can start fixing your files. Kind regards, Haroon Z
$25 USD in 1 day
5.6
5.6

Excel-based data integration and troubleshooting is a strong match for my experience in data analysis, data processing, and operational problem-solving. I can work through broken calculations, trace inconsistencies, and repair formulas that need to look up and combine information across multiple worksheets. My Excel and data integration skills are particularly relevant to spreadsheets with different layouts and custom matching rules. I am detail-oriented and accustomed to organizing complex information carefully, which helps ensure corrected formulas remain accurate and practical for ongoing use. My broader background in automation and digital operations also supports efficient, reliable spreadsheet workflows. I would be glad to apply this technical and detail-focused approach to repairing your Excel files and delivering dependable results.
$20 USD in 40 days
5.4
5.4

Hello, the fastest way to stabilize these workbooks is to separate the matching logic from the final lookup formulas, so each layout can use a clear rule instead of repeated fixes. I’ve worked with multi-sheet data flows where values must be matched, combined, and validated across inconsistent structures. I’m comfortable with complex Excel formulas, custom lookup logic, error tracing, and VBA where it genuinely simplifies the workbook. I’d start with one broken example and trace its source sheets, expected result, and matching rule. That will confirm whether the issue is formula logic, inconsistent keys, or layout-specific references before applying the fix elsewhere. Send me one affected workbook and I can begin with the first broken formula. Would that work for you? Kind regards.
$20 USD in 40 days
0.0
0.0

I understand you want your broken Excel formulas fixed so each sheet correctly looks up and pulls in information from your other sheets, even where the layouts don't match. I have experience with complex Excel formulas and combining data from multiple sheets, and I'd rebuild the lookups with XLOOKUP or INDEX and MATCH, using multiple conditions where one column isn't enough to find the right row. Based on my previous experience, most broken lookups come from hidden spaces, numbers stored as text or slightly different names between sheets, so I'd clean those inside the formula with TRIM and VALUE instead of changing your original data. For sheets with different layouts, I'd set up clear matching rules that look up by header name rather than fixed column positions, so the formulas keep working if columns move. I'd test every result against a few rows checked by hand and leave short notes explaining each formula. Most fixes like this can be done the same day. I can start work right away and contact me to discuss more details. Thanks. Smit
$20 USD in 40 days
0.0
0.0

Leadville, United States
Payment method verified
Member since Oct 28, 2026
₹1500-12500 INR
$15-25 USD / hour
$250-750 USD
$15-25 USD / hour
£250-750 GBP
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
₹1500-12500 INR
$250-750 CAD
₹600-1500 INR
$30-250 USD
₹100-400 INR / hour
₹12500-37500 INR
$10 USD
₹1500-12500 INR
$30-250 USD
£250-750 GBP
$2-8 USD / hour
₹12500-37500 INR