You will get all Lookup Formula- Vlookup, Hlookup, Xlookup, Index+Match, Filter,TextJoin
Top Rated
Top Rated
Project details
1. You will get any lookup solution.
2. Vlookup can search from the right side columns of the Lookup column. But I can provide the solution as if you can lookup from any column.
3. Sometime, you may get error (#N/A, #Value, etc) in vlookup formula. My unique approach will solve this kind of annoying error.
4. Vlookup returns only one matching and the first matching. But in my solution, I will provide the solution as if you can get the first or even last matched result.
5. Even if you want all lookup results and join them all together, that kind of solution also possible.
2. Vlookup can search from the right side columns of the Lookup column. But I can provide the solution as if you can lookup from any column.
3. Sometime, you may get error (#N/A, #Value, etc) in vlookup formula. My unique approach will solve this kind of annoying error.
4. Vlookup returns only one matching and the first matching. But in my solution, I will provide the solution as if you can get the first or even last matched result.
5. Even if you want all lookup results and join them all together, that kind of solution also possible.
Data Tool
Microsoft ExcelWhat's included $40
These options are included with the project scope.
$40
- Delivery Time 1 day
- Number of Revisions 2
- Source Code
41 reviews
(40)
(1)
(0)
(0)
(0)
This project doesn't have any reviews.
MS
Michael S.
May 18, 2026
Excel Automation Expert
Md did an amazing job. Worked perfectly the 1st time. Made adjustments based on my changes and the 2nd iteration is even better. Will be using him for all my excel needs
.
.
BG
Bruce G.
Feb 26, 2026
Excel Macro Repair Specialist Needed
SM
Sean M.
Jan 27, 2026
PDF to Excel Data Extraction Specialist Needed
Md is excellent. I could not give him a stronger recommendation. He communicates well and works fast. He requires minimal guidance and understands the task well. If you are comparing freelancers, you would do well to choose him!
MB
Minhaj B.
Jan 22, 2026
Build Automated Agent Performance Tracker on Google Sheets
Great experience working with him. Very professional, on time, and highly responsive. He understood the project perfectly and delivered a high-quality Google Sheets KPI spreadsheet. Definitely recommended.
RM
Rob M.
Jan 4, 2026
Further Development to include new APIs
Would highly recommend Mohashin. His attention to detail in a clear, understandable way is excellent. I am continuing to work with Mohashin on additional projects.
About Md Mohashin
Excel VBA, Add-ins, Google Sheet, AppScript, Power Automate, API
100%
Job Success
Chattogram, Bangladesh - 6:43 am local time
🔥 𝟭𝟬𝟬% 𝗝𝗼𝗯 𝗦𝘂𝗰𝗰𝗲𝘀𝘀 |⚡𝟳𝗱𝗮𝘆𝘀 𝗙𝘂𝗹𝗹-𝘁𝗶𝗺𝗲 𝗳𝗿𝗲𝗲𝗹𝗮𝗻𝗰𝗲𝗿 | 📞 𝟮𝟰𝘅𝟳 𝗭𝗼𝗼𝗺 𝗖𝗮𝗹𝗹 | 🏆 𝗧𝗼𝗽-𝗥𝗮𝘁𝗲𝗱 𝗣𝗹𝘂𝘀 𝗕𝗮𝗱𝗴𝗲 (𝗧𝗼𝗽 𝟯% 𝘁𝗮𝗹𝗲𝗻𝘁) | 🕒 𝟭𝟱+ 𝗬𝗲𝗮𝗿𝘀 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲
────────────────────────────────────────────────────────
🎯 𝗠𝗼𝗿𝗲 𝗱𝗲𝘁𝗮𝗶𝗹𝘀 𝗼𝗳 𝗠𝘆 𝗘𝘅𝗽𝗲𝗿𝘁𝗶𝘀𝗲
My skill set spans a wide range of tools and technologies, including:
💼 Business Application Development
- Custom Excel, Access, and Word applications: eCommerce, Student Management, HR, Inventory, Cashflow, and Real Estate.
- Automated Excel templates for invoices, mail merge, and reporting.
- Data entry automation with validation and workflow logic.
- Custom UserForms for Excel and Access to capture complex data.
- Office Scripts & Custom Ribbon design with company branding and color theme.
- Integration of Excel & Word templates with SharePoint and Power Automate flows.
📊 𝗘𝘅𝗰𝗲𝗹 VBA (Visual Basic for Application) & Power Tools
- Automate repetitive workflows: bulk emails via Outlook & Gmail, template population, data cleaning, and processing.
- Fix and optimize existing vba code; create bulletproof, error-proof automation.
- Advanced Excel formulas.
- Pivot Tables, Power Pivot, Data Models
- Complex dashboards: Gantt charts, Waterfall, KPI visuals, dynamic interactive charts.
- Custom Add-ins with company branding, secure authentication, ready for commercial use.
- Integration with SQL, web data sources, APIs, and SharePoint.
🗃️ 𝗔𝗰𝗰𝗲𝘀𝘀 Database Automation with VBA (Visual Basic for Application)
- Automate forms, reports, and queries to streamline business processes.
- Integrate Access with Excel, SharePoint, and APIs for real-time data flow.
- Build custom applications: inventory management, HR tools, student management, cash flow, and sales tracking.
- Automate data entry, validation, and report generation.
- Create complex relational databases with optimized queries for high performance.
- Develop secure front-end forms with role-based access and user-friendly interfaces.
📝 Word & Document Automation with VBA (Visual Basic for Application)
- Populate Word templates dynamically from Excel or Access data.
- Automated mail merge for bulk letters, reports, and contracts.
- Integration with Excel & SharePoint for seamless workflow.
- Custom macros to generate formatted documents quickly.
🖌️ Custom Ribbon & Office Design
- Custom Ribbon tabs in Excel, Word, and PowerPoint with company branding
- Color themes, icons, and buttons for workflow efficiency
⚡ Power Query & Data Transformation (M Language)
- Extract, clean, and transform data from Excel, Access, web, SQL, and CSV sources.
- Use advanced M formulas.
- Merge multiple data sources for dashboards and reporting.
- Automate recurring transformations for operational efficiency.
📈 Power BI & Data Visualization
- Create interactive dashboards with KPIs, charts, waterfalls, Gantt charts, and complex Excel-style visuals
- DAX formulas: CALCULATE, SUMX, FILTER, ALLSELECTED
- Build automated models for real-time reporting
- Data connections with SQL, SharePoint, Web APIs
🌐 Web & Data Automation
- Web scraping & Selenium integration (no software install needed)
- Structured data extraction from websites, directories, and CRMs
- Automated data pipelines into Excel, Sheets, or databases
With this toolkit, I can streamline your processes, visualize your data, and automate repetitive tasks—no matter the complexity.
────────────────────────────────────────────────────────
🎯𝗚𝘂𝗮𝗿𝗮𝗻𝘁𝗲𝗲𝗱 𝗤𝘂𝗮𝗹𝗶𝘁𝘆 𝗦𝗲𝗿𝘃𝗶𝗰𝗲
My 100% job success score and Top Talent badge on Upwork place me among the top 3% of professionals, reflecting my commitment and ensuring you receive the highest quality service.
🎯 𝗤𝘂𝗶𝗰𝗸 𝗳𝗲𝗲𝗱𝗯𝗮𝗰𝗸
I am a full-time freelancer, available 7 days a week. Expect fast responses, proactive updates, and same-day troubleshooting for urgent workflows.
🎯 𝗬𝗼𝘂𝗿 𝗕𝗲𝗻𝗲𝗳𝗶𝘁𝘀
Partnering with me means accessing a one-stop shop for all your data analysis, automation, and business intelligence needs. From crafting bespoke dashboards to automating workflows across platforms, I eliminate the hassle of juggling multiple freelancers or tools. You save time, reduce costs, and get scalable, high-quality solutions tailored to your goals—all under one roof.
🎯 𝗪𝗵𝘆 𝗖𝗵𝗼𝗼𝘀𝗲 𝗠𝗲
I am more than a freelancer—I am your dedicated problem-solver. My work combines technical precision with a deep understanding of your unique needs. 𝗜 𝗽𝗿𝗼𝘃𝗶𝗱𝗲 𝗽𝗲𝗿𝘀𝗼𝗻𝗮𝗹𝗶𝘇𝗲𝗱 𝗰𝗮𝗿𝗲, proactive communication, and go above and beyond to exceed expectations. Let’s turn your vision into reality and elevate your business together!
Steps for completing your project
After purchasing the project, send requirements so Md Mohashin can start the project.
Delivery time starts when Md Mohashin receives requirements from you.
Md Mohashin works on your project following the steps below.
Revisions may occur after the delivery date.
Understand the requirements, conditions, then apply correct formula