
Closed
Posted
Paid on delivery
I need help correcting some issues in my Google Sheets. I have a main sheet that is supposed to pull inventory data from a backend sheet. However, after copying a data range from another sheet, all my formulas are misaligned, and it's pulling incorrect data. The main issue is with product descriptions being pulled incorrectly. Ideal skills and experience: - Expertise in Google Sheets - Strong understanding of formulas and data referencing - Experience in troubleshooting and correcting formula errors - Attention to detail to ensure accurate data retrieval I have a downloaded copy of an EXCEL. This data needs to be in a google sheet.
Project ID: 40578849
80 proposals
Remote project
Active 6 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
80 freelancers are bidding on average £103 GBP for this job

Hi, I am a skilled Excel/Google sheets professional from Vietnam with 25+ years of experience. I can help you with formulas and calculations for up to 5 hours. I am currently available and ready to commence work immediately. Please let me know if you'd like to discuss this further. Duong
£50 GBP in 2 days
9.6
9.6

Hello Samanthan, I can fix the misaligned formulas in your Google Sheets, ensure your main sheet correctly pulls inventory data from the backend sheet, and verify that all references are aligned and working accurately.
£20 GBP in 1 day
8.9
8.9

Hello, I use both Excel and Google sheet for years and know both well. I have extensive experience with troubleshooting and correction different errors. I could help you with this error correction. I could do it or today evening or tomorrow. Please let me know if you are interested in my services. Regards, Alex.
£30 GBP in 2 days
7.7
7.7

Hi, can u pls share link of sheet in chat?
£100 GBP in 2 days
7.4
7.4

Hi there, I understand your Google Sheets inventory system was working correctly until a copied data range caused the formulas and references to become misaligned, resulting in incorrect product descriptions and inventory data. I am confident I can quickly diagnose the root cause, realign the formulas, and restore accurate data synchronization between your backend and main sheet without disrupting the existing workflow. My approach will be to first audit the workbook structure, identify where row or column references shifted, then systematically repair the formulas, lookup logic, named ranges, and dependent references. I'll validate that every product description, inventory value, and linked field is pulling from the correct source, then migrate your Excel file into Google Sheets while preserving formulas, formatting, and functionality. Where appropriate, I'll optimize the formulas to make the workbook more resilient against future data updates and accidental copy/paste issues. To ensure long-term reliability, I'll thoroughly test the entire workflow, verify data integrity across all linked sheets, and document any key changes so the spreadsheet remains easy to maintain. Are your inventory lookups currently built with VLOOKUP/XLOOKUP, INDEX-MATCH, QUERY, or ARRAYFORMULA, and approximately how many linked sheets are involved? I'm ready to start immediately. Warm Regards, Aneesa.
£100 GBP in 1 day
7.1
7.1

AVAILABLE TO START IMMEDIATELY..,,. I will meticulously correct your Google Sheets formulas, restore accurate inventory data pulling and product descriptions, and integrate your Excel data into the backend Google Sheet. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
£51 GBP in 1 day
6.6
6.6

⭐⭐⭐⭐⭐ Fix Google Sheets Formula Issues for Accurate Data Retrieval ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project needs and see you're looking for help with Google Sheets. You have no need to look any further; Zohaib is here to assist you! My team has completed over 50 similar projects for Google Sheets. I will carefully review your sheets, fix the misaligned formulas, and ensure your product descriptions pull the correct data. ➡️ Why Me? I can easily fix your Google Sheets issues as I have 5 years of experience in data management and formula troubleshooting. My expertise includes Google Sheets, data referencing, and error correction. Additionally, I have a strong grip on Excel data import and integration, which will ensure a smooth transition to your Google Sheets. ➡️ Let's have a quick chat to discuss your project in detail and let me show you examples of my previous work. I look forward to discussing this with you! ➡️ Skills & Experience: ✅ Google Sheets ✅ Excel Data Import ✅ Formula Troubleshooting ✅ Data Referencing ✅ Error Correction ✅ Inventory Management ✅ Data Analysis ✅ Attention to Detail ✅ Spreadsheet Optimization ✅ Data Validation ✅ Problem Solving ✅ Report Generation Waiting for your response! Best Regards, Zohaib
£150 GBP in 2 days
6.6
6.6

Hello I have extensive experience with both Excel and Google Sheets. Also, I have extensive experience with formulas and references. I am familiar with issue after copying a data range from another sheet, and I know how it can be fixed.
£22 GBP in 1 day
6.3
6.3

As a highly skilled and experienced Excel and Google Sheets specialist, I understand how critical accurate data management is in any project. I've spent years mastering formulas and data referencing, providing me with the expertise needed to swiftly identify and rectify errors-just as you require. My meticulous attention to detail guarantees correct data retrieval, even when faced with complex situations such as misaligned formulas or incorrect product descriptions. Having worked with international clients, my communication skills are top-notch, augmenting smooth collaboration with remote teams. You can expect regular updates and fast responses to your messages while I work diligently to resolve your Google Sheets issues. My 5-star profile and positive client feedback also vouches for my reliability, timely delivery, and efficient manner of working. In short, I'm not just a freelancer who completes tasks; I'm your flexible virtual assistant ready to solve problems and optimize your data management concerns in the long term. Let's get your Google Sheets back on track together!
£45 GBP in 1 day
5.5
5.5

Hey! We’re a team of 62 professionals specializing in Google Sheets automation with 9+ years of experience fixing complex formulas, references, and inventory tracking systems. Here's how we can help: - Correct misaligned formulas and restore accurate data references - Fix product descriptions and inventory data synchronization issues - Review sheet structure to prevent future formula mismatches - Validate results to ensure reliable and consistent data retrieval Could you clarify whether the formulas use standard cell references, named ranges, or functions like INDEX/MATCH or XLOOKUP throughout the workbook?
£135 GBP in 7 days
5.4
5.4

Hi, I can help fix this for you. I’m experienced with Google Sheets and troubleshooting formula/data reference issues. The problem sounds like your formulas are using relative references or the pasted range shifted cell links, causing product descriptions to pull incorrectly. I’ll realign the formulas, fix the references to your backend sheet, and make sure the inventory data pulls accurately. I can get started right away. Thanks!
£150 GBP in 3 days
5.2
5.2

Hi, I can quickly fix your Google Sheets formulas and restore the correct inventory data references.
£20 GBP in 1 day
5.2
5.2

I can quickly identify and fix the formula issues in your Google Sheets. With 4+ years of experience in Google Sheets, Excel, data processing, and troubleshooting, I have resolved many problems involving broken references, incorrect lookups, and misaligned formulas after data imports or copied ranges. I will: • Identify why the formulas became misaligned. • Correct product description lookups and all affected references. • Repair VLOOKUP, INDEX/MATCH, XLOOKUP, FILTER, ARRAYFORMULA, or any related formulas. • Verify that inventory data is pulled accurately from the backend sheet. • Test the sheet thoroughly to ensure everything works correctly before completion. I pay close attention to detail and focus on delivering accurate, reliable results without disrupting your existing workflow. I can start immediately and resolve the issue as quickly as possible. I look forward to helping you get your spreadsheet working perfectly again. Best regards, Rajaoul Haque
£20 GBP in 1 day
4.8
4.8

Hey, sounds like your row references shifted when you pasted that new range in, so the product description formulas are now pointing at the wrong cells. I’d open both sheets side by side, check whether it’s VLOOKUP or INDEX/MATCH pulling the data, and rebuild the references so they lock properly with absolute refs. This kind of misalignment usually cascades to other columns too, so I’d check those while I’m in there. Happy to work within your budget — is the backend sheet still structured the same way it was before you copied the new range in?
£22 GBP in 1 day
5.1
5.1

Hi, I can fix the misaligned formulas and ensure the correct product descriptions are pulled from the backend sheet. I have strong experience with Google Sheets, Excel formulas, lookups, and data referencing issues. I will carefully review the copied ranges, correct all broken references, and verify the inventory data for accuracy. I can also convert your downloaded Excel file into a properly working Google Sheet without losing formulas or formatting. I am ready to start immediately and can provide a quick sample fix first.
£30 GBP in 1 day
4.9
4.9

I can help fix your Google Sheets inventory pull so product descriptions map correctly again. When copied ranges cause shifted references, the usual culprit is broken relative/absolute cell addressing, displaced column alignment, or formulas being interpreted against the wrong source range. I’ll review the main sheet’s lookup/index/match or array logic and confirm the exact backend range feeding it. Then I’ll correct the references (using stable absolute ranges where needed), ensure the destination columns line up with the intended fields, and re-test by pulling a small sample to verify descriptions, SKUs, and quantities match the backend. You’ll end up with formulas that remain accurate even after future copy/paste or range expansion, with clean, consistent referencing across the sheet.
£20 GBP in 6 days
4.0
4.0

Hi there, I can quickly fix the misaligned formulas causing wrong product descriptions in your main sheet. I'll audit range references, correct absolute/relative refs, and fix pull lookups so descriptions match backend data. Share access and I'll correct formulas, test results across cases, and leave clear notes. Thanks, Wilfred
£250 GBP in 2 days
4.2
4.2

Hi, I'm interested in your requirements. With utmost respect to your time and project at hand, I express my sincere interest in the task. Apart from the mentioned languages and APIs, my proficiency with Google Sheets specifically can be an asset for your project. Over the years, I have developed a strong hold on Google Sheets, capable of understanding complex formulas, and troubleshooting potential errors effectively. With my expertise I can easily fix the data misalignment issue you are facing within no time. Apart from technological proficiency, my crucial asset as a developer is my attention to detail. I value precision and accuracy when it comes to handling data. For this very reason, I assure you that post completion, your main sheet will present corrected and truthful information derived from your backend sheet; product descriptions will no longer be pulled incorrectly. Hoping to hear a positive response from you soon. Feel free to contact me for any further discussion or clarification needed. Thank you for considering my candidacy for your project and I look forward to potentially working with you and ensuring smooth sailing across your Google Sheets! Let's have a chat for more details. Thanks!
£185 GBP in 3 days
4.1
4.1

Hello, I understand your main Google Sheet is pulling incorrect inventory data after a copied data range shifted the formula references, resulting in misaligned product descriptions and inaccurate lookups between your frontend and backend sheets. For your project my plan is to first audit the existing formulas, named ranges, and data structure to identify where the references became misaligned, followed by correcting the lookup logic using the most appropriate Google Sheets functions such as XLOOKUP, INDEX MATCH, FILTER, or QUERY based on your workbook. Finally, I will validate every product description against the backend data, optimize the formulas for reliability, and ensure future updates or copied ranges do not break the sheet again. As final deliverable, you will receive a fully corrected Google Sheets workbook with accurate inventory lookups and optimized formulas, along with brief documentation explaining the key changes so you can maintain the sheet confidently in the future. One thing I'd like to confirm before we start: are your inventory lookups currently based on product IDs, SKUs, row positions, or another unique identifier? I'd be happy to review the sheet with you and resolve the formula issues quickly. Best Regards, Imran
£85 GBP in 1 day
4.2
4.2

I can fix the issues ASAP Kindly send me a message we'll discuss further Looking forward to hearing from you Thank you.....
£135 GBP in 1 day
4.1
4.1

Aberdeen, United Kingdom
Member since Jul 13, 2026
£20-250 GBP
$10-200 USD
₹400-750 INR / hour
£20-250 GBP
£20-250 GBP
$10-30 USD
₹1500-12500 INR
$15-25 USD / hour
$30-250 CAD
min $50 USD / hour
₹400-750 INR / hour
£100-1200 GBP
₹750-1250 INR / hour
₹1500-12500 INR
$300-500 USD
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
$30-250 NZD
$2-8 USD / hour
₹30000-40000 INR