Find Jobs
Hire Freelancers

Advanced Excel Drop-down Lookup System

$30-250 USD

Closed
Posted 14 days ago

$30-250 USD

Paid on delivery
I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the success of this project.
Project ID: 38069332

About the project

83 proposals
Remote project
Active 8 days ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
83 freelancers are bidding on average $112 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD in 4 days
4.9 (610 reviews)
8.6
8.6
User Avatar
Hello, Our team specializes in Excel and data entry, ensuring accurate and efficient solutions tailored to your needs. We prioritize understanding your goals and project requirements, delivering high-quality results within your timeline. With advanced Excel skills, we organize and analyze data effectively, ensuring accuracy throughout. We welcome your feedback and offer ongoing support as needed. We're eager to collaborate and deliver exceptional results for your Excel and data entry projects. Best regards, Khushi
$150 USD in 3 days
4.8 (352 reviews)
7.4
7.4
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$240 USD in 7 days
5.0 (194 reviews)
7.1
7.1
User Avatar
Hi there I was very interested in your MS Excel project. I'm an Access/Excel/SQL/VBA expert and a mathematician from Georgia- a full-time freelancer. I have been coding for over 20 years in this field. Please visit https://www.freelancer.com/u/zu02?w=f Here you can also find reviews such as: "Zurab is an MS ACCESS genius","Zurab is Messi of Office" etc. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thanks! Zurab
$99 USD in 2 days
4.7 (86 reviews)
6.5
6.5
User Avatar
Hi, I can develop Excel VBA Macro to create drop down lookup system as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
$140 USD in 7 days
4.8 (148 reviews)
6.2
6.2
User Avatar
Hi, I have a few years of experience in programming VB and VBA macros, importing, exporting, sorting, calculating, and manipulating data in Excel, what can make me the perfect fit for this project. I can create drop-down menus and VBA macro to look up and calculate values automatically in a series of tables. Please feel free to contact me if you have any questions or would like further information on my skillset or profile. Best regards, Remis
$250 USD in 14 days
4.9 (23 reviews)
4.6
4.6
User Avatar
Hello sir, I am an experienced Cost and Management Accountant and Financial Analyst having more than 7 years experience in Accounting and Finance. ai have served more than 3 years with top rated audit firm KPMG.I can do this job efficiently as per instructions within the short time with 100% accuracy. Looking for your response. Thanks
$99 USD in 1 day
5.0 (17 reviews)
4.2
4.2
User Avatar
Being a data analyst for several years, I have developed an intimate understanding of Excel and its advanced functions that are just perfect for your project. I have created numerous drop-down lookup systems like the one you're describing, incorporating multiple variables intelligently to extract relevant information from databases with ease. With my expertise, you can expect nothing less than an efficient, user-friendly spreadsheet that allows for agile decision-making. In addition to my prowess in Excel, I am also well-versed in processing both numerical and text data. The unique challenge your project poses by requiring efficient searching and reformatting of tables is one that I thoroughly enjoy. Through my proficiency in G-Suite and Python, I can ensure a comprehensive solution that perfectly aligns with your needs. Above all else, I am known for my commitment to providing exceptional service even after the project's completion. I will go above and beyond to provide you with all the necessary support to ensure the successful implementation and usage of this drop-down lookup system. Let's collaborate to leverage the full potential of data and transform how efficiently you make decisions!
$80 USD in 1 day
5.0 (12 reviews)
4.0
4.0
User Avatar
No visible formulas, No VBA, No Macro!! Hail and well met, noble seeker of Excel enchantments! Behold, I, a seasoned sorcerer of the mystical realm of MS Excel, wield over 15 cycles of experience in the arcane arts of spreadsheets. My forte lies in the ancient craft of Excel Reports Automation using Power Query, weaving together disparate sources into a harmonious tapestry of data at your command. Fear not, for my dedication transcends mere project completion. I pledge unwavering after-service support, a shield against the dark forces of data-related queries. Your triumph is my quest, and as your steadfast ally, I vow to stand by your side through our epic saga. My repertoire includes: Unleashing any Excel Formula at your behest Cleansing and formatting MS Excel Spreadsheets with precision Casting Conditional Formatting spells for visual splendor Standardizing MS Excel Spreadsheets for order in chaos Conjuring Excel Reports with a wave of my wand Summoning Pivot Tables, Pivot Charts, and spreadsheet Tables for your viewing pleasure Crafting Power BI charts and reports to illuminate your path Do not tarry, accept my offer, and venture forth into the realm of data wonders. Visit my portfolio to glimpse past conquests. Regards, Emad, your Excel mage extraordinaire. https://www.freelancer.com/u/EmadOwaida?frm=EmadOwaida&sb=t
$120 USD in 2 days
5.0 (1 review)
3.5
3.5
User Avatar
Hey Simon, I have carefully read the project description for the Advanced Excel Drop-down Lookup System. To create this system, I will utilize my expertise in Visual Basic, Data Processing, Excel, Microsoft Access, and Visual Basic for Apps. I plan to construct a sophisticated drop-down lookup system that will streamline your decision-making process. By incorporating multiple variables and efficient searching techniques, the system will accurately determine prices from the database. I will reformat the tables as needed to ensure seamless integration and easy access to information. With my proficiency in MS Excel Advanced Functions and experience in handling numerical and text data, I am confident in delivering a solution that meets your requirements. The end product will enhance your workflow by providing agile and precise pricing based on selected variables. Please initiate the chat to discuss this project further. Best regards
$30 USD in 1 day
5.0 (2 reviews)
3.0
3.0
User Avatar
* I will complete the project in one hour* Hello, I read your project and I am ready to start working NOW I am expert in data entry, excel and google sheets I am expert in formulas, functions, pivot, data visualization, dashboard, charts and graphs. Also, I have original version of MS office Programs I will provide a sample, Unlimited revisions and 100% Satisfaction. Let’s discuss the details on chat Regards, Chintan Shah
$30 USD in 1 day
5.0 (6 reviews)
2.7
2.7
User Avatar
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA
$30 USD in 1 day
5.0 (10 reviews)
2.5
2.5
User Avatar
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
$45 USD in 1 day
4.6 (10 reviews)
2.5
2.5
User Avatar
If you are searching for an Excel guru with a knack for not just navigating spreadsheets, but also crafting powerful and innovative solutions to complex problems, then look no further! With advanced proficiency in MS Excel functions and an extensive understanding of complex data analysis, I have the ideal skill set for constructing your advanced drop-down lookup system. My experience includes working with numerical and text data, and I'm particularly knowledgeable about creating drop-down lookups for entire sheets. When it comes to data processing, I operate both efficiently and meticulously; two qualities that will be absolutely crucial for this project. And if table reformatting is needed, count on me to optimize your database seamlessly. Moreover, my knowledge of VBA programming and macros will allow me to automate as much as possible, saving you precious time while maximizing efficiency. In conclusion, my comprehensive understanding of Excel combined with my dedication to delivering top-notch quality results make me the perfect fit for this assignment. You can trust that my consolidated approach will simplify your decision-making process by providing agile and accurate prices based on selected variables. Reach out to me now; let’s bring efficiency and accuracy to your business together!
$140 USD in 2 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Hi there, I am a Data Scientist with excellent knowledge and enthusiasm for Microsoft application development. I can do advanced Excel, Word, Access, Power BI, and Outlook and create VBA macros. Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, Capabilities, and Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work. I am willing to devote my time and energy to improving the service with timely, accurate, and professional results. Building trust and a long-term relationship with customers is my main objective. Improving https://www.freelancer.com/u/IcsfIT789 Let's discuss this further via chat, and I'll start your project right now. Thanks IcsfIT
$100 USD in 3 days
5.0 (2 reviews)
2.5
2.5
User Avatar
Hi dear friend I am proficient in programming in asp.net core, vb.net, SQL, Excel, VBA ,Powershell Scripts and automation tools in the Windows environment.  Plus 15 years of challenging experience in organizations and 5 years in freelance work. I have done more than 100 projects, including sales CRM applications and graphic PDF invoices, management dashboards in Excel, SAP Excel warehousing, automation programs for technical calculations and human resource management, personnel salary, fuzzy calculations, calculation of technical service rates and mass document format convertors like word to mysql. and also Im expert in Windows Automation Systems and developing system and security programs in windows networks. There is nothing that I can't handle in Windows and specially Excel VBA ! once our chat starts ofcourse If you were interested, I will gladly send you some of my work samples that may not be in my current portfolio yet. In addition, I have strong problem-solving and creativity skills that have attracted my clients in the past. I invite you to try my services and see the quality of work I offer. to clarify up your job just if possible for you please send me some of your current documents+desired output samples and a detailed video of your workflow i will try my best to create a flexible and innovative excel vba based application for your future use. Hoping for a successful and long-term cooperation
$130 USD in 1 day
5.0 (1 review)
1.6
1.6
User Avatar
With over 5 years of professional experience, I've honed my skills in data processing and Excel to a fine edge. The task at hand aligns perfectly with my skill set, particularly with the need to create an advanced drop-down lookup system - a feat that I've accomplished successfully in the past. Thank you for considering me as a potential partner for this project
$35 USD in 1 day
5.0 (3 reviews)
1.2
1.2
User Avatar
Having been in the field as a freelance data analyst for over 5 years, I have developed an unparalleled proficiency in Excel and advanced functions which enables me to automate complex tasks such as drop-down lookup systems effortlessly. Throughout my career, I have managed diverse types of data from both numerical and text sources and have honed my skills in organizing and structuring large datasets efficiently for optimal use, enabling quick retrieval of information irrespective of system size. Furthermore, my ability to comprehend clients' requirements thoughtfully allows me to customize solutions that precisely meet their needs. In the case of your project, coming up with a comprehensible yet powerful drop-down lookup tool that streamlines your decision-making process is something I am very well acquainted with on a daily basis. Lastly, my proficiency with complementary tools such as MySQL, Tableau, and Python may greatly complement this project. For instance, while delivering similar projects before, I've directly integrated Excel tools with database systems like MySQL, allowing for more robust and precise data look-up mechanisms. Considering these factors together, I believe I'm fully equipped to not only deliver the job but also exceed your expectations in a timely fashion!
$30 USD in 2 days
5.0 (1 review)
1.3
1.3
User Avatar
Hello Prospect Client, After read your project detail as freelancer with experience 7 years+ as data analist with python and excel, I can help your need.. I hope we can be good client started give this project to me. My service not just send this project but I try fulfill what you need until it facing the requirement Warm regards, Indrawan Bayu
$111.15 USD in 3 days
5.0 (1 review)
0.9
0.9
User Avatar
I have many years of experience on Visual Basic, Data Processing, Excel, Microsoft Access, Visual Basic for Apps
$110 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDONESIA
Bitung, Indonesia
5.0
4
Payment method verified
Member since Mar 23, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.